select sal from (select distinct sal from emp order by sal desc) where

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

Question Posted / chiru

Answer Posted / chiru

select sal from (select distinct sal 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 many sql statements are used? Define them.

776

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2762

What is pl sql code?

752

What is the sql case statement?

749

What is difference between pls_integer and integer?

711

How many clustered indexes can you have?

729

how to calculate expressions with sql statements? : Sql dba

715

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

903

What is sql stand for?

744

Do foreign keys improve performance?

748

What will you get by the cursor attribute sql%found?

701

What does 0 mean in sql?

694

What are different types of sql?

757

How to install oracle sql developer?

772

How many sql commands are there?

851