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

Difference between primary key and clustered index?

998

Explain the truncate command? : SQL Server Architecture

1166

How can windows applications connect to sql servers via odbc?

1116

What is sql server locking?

981

What is collation sensitivity?

1054

What are the export options of ssrs?

173

How to backup encryption key ?

182

what is the difference between Tabular and Matrix report?

170

What is a schema in ms sql server 2005?

962

How column data types are determined in a view?

955

How to create function without parameter in sql server?

1049

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1024

What is the stuff?

991

How to fine-tune reports?

266

What is normalization? Describe its different types.

1099