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

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1053

What is rename in sql?

1019

What types of commands can be executed in sql*plus?

1167

Can we use delete in merge statement?

1101

Is not equal in sql?

1064

Why do we use %rowtype & %type in plsql?

1100

How do I access sql anywhere database?

1023

How many types of sql are there?

1047

what are the join types in tsql? : Transact sql

1107

How do rank () and dense_rank () differ?

1109

What is user defined functions?

1031

What found sql?

995

Is sql a backend language?

1146

What is difference between pl and sql?

1111

What are the topics in pl sql?

1024