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

Why we use pl sql?

1009

What is the need of merge statement?

1093

how can we know the number of days between two given dates using mysql? : Sql dba

1090

What has stored procedures in sql and how we can use it?

1129

What is #table in sql?

1183

Why is there a need for sqlcode and sqlerrm variables?

1104

What is using in sql?

1142

can sql servers linked to other servers like oracle? : Sql dba

1054

Is primary key a clustered index?

1014

Is it possible to update views?

1007

What are the methods of filing?

994

Can sql developer connect to db2?

1104

How do I kill a query in postgresql?

1189

What are the types of subqueries?

1103

How do I run pl sql in sql developer?

1176