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

8 Answers
11438 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is open database communication (odbc) in oracle?

971

How can I combine multiple rows into a comma-delimited list in oracle?

1018

How to define a cusotmer as a supplier in ORACLE R12

2195

How to create a server parameter file?

1097

Can multiple cursors being opened at the same time?

1036

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2203

How to get a create statement for an existing table?

927

What are temporal data types in oracle?

1086

What is bulk load in oracle?

1030

What is the difference between sharding and partitioning?

952

Differentiate between post-database commit and post-form commit?

995

What is oracle rownum?

910

How to omit columns with default values in insert statement in oracle?

1018

How to assign a tablespace to a users in oracle?

1013

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2103