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

what is try_catch block in procedure

1755

What is difference between procedure and trigger?

984

How to use transactions efficiently : transact sql

1062

Can we create index on primary key?

977

Does varchar need length?

1000

Explain table and field in sql?

1068

how do you know if your mysql server is alive? : Sql dba

1082

What is difference between hql and sql?

1085

Where is pl sql used?

958

What is procedure explain with program?

1026

What is data control language?

994

what are the performance and scalability characteristics of mysql? : Sql dba

1001

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1114

where are cookies actually stored on the hard disk? : Sql dba

1033

What are the different types of dbms?

1017