select e1.sal from emp e1 where 2=(select count(distnct (e2.sal) from emp

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

Question Posted / srinivas

Answer Posted / srinivas

select e1.sal from emp e1 where 2=(select count(distnct
(e2.sal) from emp e2 where e2.sal>=e1.sal)

Is This Answer Correct ?

33 Yes

32 No

Please Help Members By Posting Answers For Below Questions

What is the difference between value type and reference type?

918

Can we use having clause without group by?

979

How to create a simple table to test triggers in ms sql server?

973

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1018

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

880

What is index in an assignment?

950

How is sql server used?

955

Can a database be shrunk with users active?

1125

What is db stored procedure?

876

explain what is raid and what are different types of raid configurations? : Sql server database administration

999

How to assign new column names in a view?

914

what is nonclustered index

954

New concepts of sql server 2005 use in your project.

2357

Which is better statement or preparedstatement?

922

Can you tell me about the concept of ER diagrams?

1063