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

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

Question Posted / k.thrilok kumar

Answer Posted / k.thrilok kumar

select rownum, sal from (select * from emp order by sal
desc) where rownum<=3

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why cross join is used?

825

Can a foreign key be a duplicate?

682

What are triggers and its uses?

790

How can you get sql*loader to commit only at the end of the load file? : aql loader

747

How do I start sql from command line?

707

What is delete command in sql?

764

How to change sql*plus system settings?

721

What is a scalar value in sql?

806

explain advantages of myisam over innodb? : Sql dba

802

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

734

what is data integrity? : Sql dba

782

How do I start pl sql?

671

what are date and time data types in mysql? : Sql dba

688

What is difference between mysql and postgresql?

705

What are the two different parts of the pl/sql packages?

791