select sal from (select sal from emp order by val desc) where rownum <

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

Question Posted / debanjan rudra

Answer Posted / debanjan rudra

select sal from (select sal from emp order by val desc)
where rownum < 4;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Is pl sql a scripting language?

1013

What does the base_object_type column shows in the user.triggers data dictionary view?

1029

What is the most restrictive isolation level? : Transact sql

1069

What is data control language?

974

how do you know if your mysql server is alive? : Sql dba

1063

What are local and global variables and their differences?

1076

What is the use of index in hive?

990

Explain the uses of control file.

1026

What is rank dense_rank and partition in sql?

1006

What is %type in sql?

948

how to run 'mysql' commands from a batch file? : Sql dba

1094

What does truncate mean in sql?

1002

What is restrict in sql?

1093

how to decrement dates by 1 in mysql? : Sql dba

1007

Can we join same table in sql?

1000