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

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

Question Posted / manoj tcs

Answer Posted / manoj tcs

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to create a table index in mysql? : Sql dba

751

Is oracle and sql same?

747

Why is %isopen always false for an implicit cursor?

767

what is msql? : Sql dba

753

What's the difference between inner join and left join?

726

Is progress software supports to ( pl/sql )?

717

What is the sql query to display the current date?

758

Is sql better than excel?

701

What is the difference between local variables and global variables?

800

what is the difference between delete and truncate statement in sql? : Sql dba

761

How would you reference column values before and after you have inserted and deleted triggers?

818

What is pivot table in sql?

739

What is a sql profiler?

770

what happens if you no create privilege in a database? : Sql dba

719

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

790