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

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

Question Posted / debbie

Answer Posted / debbie

select * from (select sal 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

What is the size of partition table?

562

What are the most important ddl statements in sql?

579

What is Collation Sensitivity ? What are the various type ?

501

Does sql profiler affect performance?

561

Define select, insert, create, delete, update, drop keywords

600

How do I save a sql query?

548

What is union?

656

What are the possible values for the boolean data field?

527

What is update query?

551

What are different types of indexes?

513

what is the difference between cluster and non cluster index? : Sql dba

559

What is procedure in pl sql?

538

Explain clause in sql?

564

What is rename command in sql?

469

What is rowtype?

573