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

explain what is mysql? : Sql dba

787

What is delimiter in pl sql?

743

How can we debug in PL/SQL?

855

How can we link a sql database to an existing android app?

732

Explain the commit statement.

848

What is out parameter used for eventhough return statement can also be used in pl/sql?

800

Is natural join and inner join same?

654

how do you know the version of your mysql server? : Sql dba

690

What do you know by pl/sql cursors?

759

how to use in conditions? : Sql dba

693

Does a join table need a primary key?

708

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

903

What is pragma in pl sql?

766

What is sql resultset?

729

What operators deal with null?

813