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

What is an anonymous block?

1216

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1081

what is the use of system.effective.date variable in oracle?

1085

How to use fetch statement in a loop?

1006

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4499

Explain alias?

1106

Does facebook use oracle?

1017

Is there an oracle sql query that aggregates multiple rows into one row?

961

Explain the use of compress option in exp command.

999

How to use values from other tables in update statements using oracle?

1065

How to retrieve data from an explicit cursor?

1037

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2113

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2087

How can we find out the duplicate values in an oracle table?

1032

Which is faster join or subquery in oracle?

973