select * from Emp e where 1=(select count(Distinct d.esal)from emp d where

write the query for find the top 2 highest salary in sql
server

Question Posted / uday

36 Answers
72791 Views
Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
E-Mail Answers

Answer Posted / uday

select * from Emp e where 1=(select count(Distinct
d.esal)from emp d where d.esal>e.esal)

i am sure that it should work.

Any thing wrong plz inform me

Is This Answer Correct ?

5 Yes

9 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do you know what are pages and extents? : SQL Server Architecture

941

How does normalization work?

865

How to add the custom code in Report?

117

What is blocking?

980

How to set the current database in ms sql server?

1009

What is the benefit of normalization?

1019

What is the difference between a view and a stored procedure?

979

What is failover clustering overview?

1021

What is the command to change the recovery model?

999

What is the difference between TRUNCATE and DROP?

1064

How real and float literal values are rounded?

1095

How to delete duplicate rows in sql server?

1056

How to replace the Query Result 'Null Value' with a text ?

971

How to edit table in sql server 2017?

880

What is meant by indexing files?

984