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

Can we use threading in pl/sql?

1017

How can you view the errors encountered in a trigger?

945

What is the difference between drop and truncate commands?

1045

What are the parameter modes supported by pl/sql?

1079

How to change sql*plus system settings?

1041

what are the differences between char and nchar? : Sql dba

1096

explain about mysql and its features. : Sql dba

1000

What is an exception in PL/SQL? What are the two types of exceptions?

1274

How to test for null values?

1020

which types of join is used in sql widely? : Sql dba

966

What is scalar function in sql?

1016

How do I create a sql script?

1083

What is the default isolation level in sql server? : Transact sql

1010

What will you get by the cursor attribute sql%rowcount?

1017

how do you control the max size of a heap table? : Sql dba

960