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 does (+) mean in sql joins?

739

How many subqueries can be nested in a statement?

693

How do you remove duplicates without using distinct in sql?

695

Is oracel sql developer written in java?

837

Can a select statement fire a trigger?

888

List out the acid properties and explain?

711

What is left join in postgresql?

749

what is schema? : Sql dba

742

What is the difference between a procedure and a function?

701

Are null values same as that of zero or a blank space?

731

What is the difference among union, minus and intersect?

731

What sql database should I use?

788

What is basic structure of pl sql?

686

what is an alias command? : Sql dba

729

how to drop an existing index in mysql? : Sql dba

714