select min(sal) from (Select sal FROM emp where rownum<=3 Order by

Find out the 3rd highest salary?

Question Posted / shaiju nair

Answer Posted / shaiju nair

select min(sal) from (Select sal
FROM emp where rownum<=3
Order by sal desc)

Is This Answer Correct ?

13 Yes

25 No

Please Help Members By Posting Answers For Below Questions

What is cte?

963

how to load data files into tables with 'mysqlimport'? : Sql dba

1079

Is there a way to automate sql execution from the command-line, batch job or shell script?

954

Why do you partition data?

1010

What is the use of sqldataadapter?

948

What is the max nvarchar size?

945

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1199

What is the purpose of using pl/sql?

1125

Are dml statements autocommit?

1029

What is column?

975

What is a pdo connection?

1008

Define join and name different types of joins?

988

What is sql catalog?

1000

what are date and time intervals? : Sql dba

1035

What is sql prepared statement?

967