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

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

Question Posted / seema

Answer Posted / seema

select sal from (select distinct sal from emp order by sal
desc ) where rownum < 3;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is trigger price?

989

What is the difference between a subquery and a join?

1108

What is rank function in sql?

1029

How do I run a sql trace?

960

How many commands are in sql?

1073

How much does sql certification cost?

1094

What is the difference between python and sql?

1005

How can a pl sql block be executed?

948

How do you know if a relationship is 2nf?

946

Can a table contain multiple foreign key’s?

997

Is null operator in sql?

1041

What is file based approach?

942

Does truncate need commit?

948

Why do we need sharding?

991

Is join and inner join the same?

1003