select ename ,sal from (select ename,sal from emp order by sal desc) w

how to retrieve the top 3 salaries of the table using rownum

Question Posted / rameshwar gupta

Answer Posted / rameshwar gupta

select ename ,sal from (select ename,sal from emp order
by sal desc)
where rownum<4

Is This Answer Correct ?

8 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Does sql*plus have a pl/sql engine?

994

What is a Mapplet?

1057

Can we use ddl statements in stored procedure sql server?

964

how can we destroy the cookie? : Sql dba

958

Is pl sql a scripting language?

969

What is oracle sql developer?

988

Explain what is a column in a table?

1040

How to check if a column is nullable before setting to nullable?

1054

what are null values? : Sql dba

896

what is oracle database ? : Sql dba

966

What is rownum in sql?

962

What is pl/sql language case sensitive?

1058

What is pl sql block structure?

973

What is sequence in sql?

936

what are properties of a transaction? : Sql dba

1015