select * from emp a where &nth in(select count(b.sal) from emp b where

How to retrieve 5th highest sal from emp table?

Question Posted / vasu

Answer Posted / vasu

select * from emp a where &nth in(select count(b.sal) from
emp b where b.sal<=a.sal);

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

how to do daily transactions with out sql* loader control file regesterd in apps?

1224

How to apply filtering criteria at group level in oracle?

587

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

545

Can multiple columns be used in group by in oracle?

552

Explain the truncate in oracle?

550

How to recover a dropped table in oracle?

608

What are the differences between blob and clob in oracle?

586

Difference between varchar and varchar2 data types?

668

Does oracle partitioning improve performance?

552

How to change program global area (pga) in oracle?

588

How to invoke the data pump import utility?

653

How to create tables for odbc connection testing?

496

How to use in conditions in oracle?

561

How do I start tns listener?

542

Explain the difference between a procedure and a function?

561