select * from (select sal from emp order by sal desc) where rownum<=3

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

Question Posted / debbie

Answer Posted / debbie

select * from (select sal from emp order by sal desc)
where rownum<=3

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

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

928

Does oracle roll back the transaction on an error?

959

What does dml mean?

927

Is pl sql a scripting language?

969

What is thread join () in threading?

944

what are the differences between binary and varbinary? : Sql dba

976

What is sequence in sql?

937

how many groups of data types? : Sql dba

970

What found sql?

893

What steps server process has to take to execute an update statement?

919

What is rownum?

923

What does subquery mean in sql?

988

What is the difference between sum and count in sql?

936

How do I run a sql query?

967

Explain the difference between drop and truncate commands in sql?

961