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 define an oracle sub procedure?

1151

How to do paging with oracle?

1004

How oracle handles dead locks?

1070

Can we connect to ORACLE db using Windows Authentication?

1264

How to convert character types to numeric types?

1138

What is oracle host variable?

1069

What suggestions do you have to reduce the network traffic?

967

How can I get column names from a table in oracle?

1052

Why do we need oracle client?

958

Can group functions be mixed with non-group selection fields?

1024

Differentiate between function and procedure in oracle.

1086

What is the parameter mode that can be passed to a procedure?

1054

How to install oracle odbc drivers?

1093

Can you drop an index associated with a unique or primary key constraint?

1022

What is memory advisor in Oracle?

1079