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 is a full text index?

923

What is 1nf normalization form?

1035

what changed between the previous version of sql server and the current version? : Sql server database administration

1008

Can two tables share a primary key?

1020

What is the use of for clause?

1118

What are the ways available in sql server to execute sql statements?

1135

How to execute a stored procedure in ms sql server?

1177

Tell me the difference between clustered and non-clustered index?

937

What is nonclustered index with included columns ?

967

What is a livelock?

966

What is the difference between Triggers and Stored Procedure?

1096

Can we return Data from 4(more than 1) tables in stored procedure?

1059

What is data source document?

1041

what are the new features in SSRS?

134

How to find Duplicate Records In table?

1015