select empnumber from emp where rownmum < 4 and salary in (select sa

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

Question Posted / ashwinee

Answer Posted / ashwinee

select empnumber
from emp
where rownmum < 4 and salary in (select salary
from emp
order by salary desc)

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is pl/sql table? Why is it used?

1014

What are transaction and its controls?

1022

Can a foreign key have a different name?

933

What is scalar data type in pl sql?

1054

Can you join views in sql?

939

What are procedures used for?

969

what is the difference between delete and truncate commands? : Sql dba

1044

How to run sql commands in sql*plus?

1157

Write a query to display the current date in sql?

1005

What are the 3 types of behavioral triggers?

1234

what are the advantages of sql ? : Sql dba

1042

Why we use join in sql?

945

Is postgresql a nosql database?

1142

what is sub-query? : Transact sql

1084

What is left join in postgresql?

1029