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

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1999

What are the advantages of oracle 12c?

1121

What are data pump export and import modes?

1019

1) Does oracle have any table which contain all the exceptions and it's code internally?

1698

How to delete a column in an existing table in oracle?

1011

What is meant by joins? List out the types of joins.

960

What are triggers in oracle?

978

What happens if the imported table already exists?

974

What is archive log in Oracle?

1071

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2251

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2248

What is a schema in oracle?

968

Explain a data segment?

1018

How to define an anonymous procedure with variables?

1065

How do you tell what your machine name is and what is its IP address?

2007