SELECT sal FROM (SELECT sal, RANK() OVER(ORDER BY sal DESC) AS rnk FROM

How to find 1st, 2nd, 3rd highest using select select
statement not using rownum

Question Posted / madhavi

Answer Posted / madhavi

SELECT sal
FROM (SELECT sal, RANK() OVER(ORDER BY sal DESC) AS rnk
FROM emp)
WHERE rnk IN (1,2,3);

Is This Answer Correct ?

14 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Why is oracle used?

909

Explain oracle’s system global area (sga).

1109

How to revoke create session privilege from a user in oracle?

981

How to create a stored procedure in oracle?

1054

How to export data to a csv file?

1247

What is recycle bin in Oracle?

1111

What do you understand by database schema and what does it hold?

1201

What is a trigger oracle?

1061

What is oracle analytical function?

1066

What is the fastest query method to fetch data from the table?

1322

How to connect to a remote server?

1088

What to do if the binary spfile is wrong for the default instance?

1025

What are the attributes that are found in a cursor?

1034

What is an oracle database table?

975

How are extents allocated to a segment?

1090