select * from emp e where 2>=(select count(distinct esal) from emp wh

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

Question Posted / krishna

Answer Posted / krishna

select * from emp e where 2>=(select count(distinct esal)
from emp where e.esal<=esal)

Is This Answer Correct ?

8 Yes

16 No

Please Help Members By Posting Answers For Below Questions

What is named query? : sql server analysis services, ssas

967

What are views in ms sql server?

1085

What is isnull() operator?

1041

What is resource governor in sql server?

998

Do you know the capabilities of cursors?

1150

What new data source types were added in ssrs 2014?

160

Does the order of columns in update statements matter?

914

What are exact numeric data types in ms sql server?

1078

Where are sql server usernames and passwords stored in the sql server?

1116

Where are stored procedures in sql server?

1066

What is acid mean in sql server?

1120

What is reference section?

1006

What is 2nf normalization?

1029

What is 'write-ahead log' in sql server 2000 ?

1057

What is difference between unique and primary key?

914