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

What is database white box testing and black box testing?

1049

Which are the different case manipulation functions in sql?

955

What are commit, rollback, and savepoint?

940

what is the difference between char_length and length? : Sql dba

993

What are types of exception?

876

how do you login to mysql using unix shell? : Sql dba

1018

How do you drop a trigger?

924

What are sql functions? Describe in brief different types of sql functions?

1013

How are functions and procedures called in PL/SQL?

1132

How does postgresql compare to oracle/db2/ms sql server/informix?

983

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1045

How is sql used in oracle?

971

Where do we use pl sql?

945

Is microsoft sql free?

1045

What are the key differences between SQL and PL SQL?

1149