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 view all columns in an existing table?

981

What are the advantages of oracle?

1069

Name the three major set of files on disk that compose a database in Oracle?

1170

How to get a list of all background sessions in the database?

1040

Define oracle database

1098

Calculate difference between 2 date / times in oracle sql?

1098

What is the implicit cursor in oracle?

1171

What is a table index?

1168

Is there a function to split a string in plsql?

1109

How do I manually create a database in oracle?

1069

How do I escape a reserved word in oracle?

1256

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1096

Explain what are the different type of segments?

1003

Explain the use of ignore option in imp command.

1086

When do we use group by clause in a sql query?

1101