select min(sal) from (select sal from emp order by sal desc) where rownum

find the third highest salary?

Question Posted / rohit kumar

Answer Posted / rohit kumar

select min(sal) from (select sal from emp order by sal
desc) where rownum <= 3

Is This Answer Correct ?

17 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What are the ddl commands?

1015

what is a database transaction? : Sql dba

1190

List the different type of joins?

1062

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1018

Does normalization improve performance?

1044

What is the usage of distinct keyword?

1069

What is rank dense_rank and partition in sql?

1045

What is sql resultset?

992

What is the difference between local variables and global variables?

1128

which types of join is used in sql widely? : Sql dba

986

How do I remove all records from a table?

1081

What is embedded sql in db2?

1023

What does desc stand for?

1075

What is plpgsql language?

1070

What is a natural join?

1078