select * from emp e where 2=(select count(sal) from emp where e.sal<=sa

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

Question Posted / ramu

Answer Posted / ramu

select * from emp e where 2=(select count(sal) from emp
where e.sal<=sal)

Is This Answer Correct ?

6 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What are the basic functions for master, msdb, model, tempdb and resource databases?

1036

Do you know sql server 2008 introduces automatic auditing?

1053

What are the types of indexes?

1133

What is sub-query in sql server? Explain its properties.

1134

What are the steps you will take to improve the performance of a poor performing query?

1022

What does COMMIT command do?

1122

What is the log shipping?

1063

Is foreign key unique?

1049

Does hive support indexing?

1004

How to disable a login name in ms sql server?

1176

Tell me what is log shipping?

1033

Which tcp/ip port does the sql server run on? How can it be changed?

1116

What is implicit cursors?

1135

Is sql server a database?

1040

What are the differences between user defined functions and stored procedures?

1137