select * from emp m where (select count(distinct sal)+1 from emp s wher

how to retrieve the top 2 salaried persons from a database?

Question Posted / srinivas

Answer Posted / srinivas

select * from emp m
where
(select count(distinct sal)+1 from emp s
where s.sal>m.sal)<=2
order by sal desc

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1040

What are the different sql languages?

1042

What is data type in database?

1001

Is nosql faster than sql?

1031

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1089

What are the disadvantages of file system?

1271

How do I count records in sql?

1016

How do I count rows in sql?

1011

What are the benefits of stored procedures?

1075

What is Collation Sensitivity ? What are the various type ?

955

Can I join the same table twice?

1054

List the various privileges that a user can grant to another user?

1047

How would you pass hints to the sql processor?

987

What is right join in sql?

1098

what is the difference between $message and $$message? : Sql dba

1003