select * from emp e where 2>(select count(esal) from emp where e.esal&

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(esal) from emp
where e.esal<=esal)

Is This Answer Correct ?

3 Yes

7 No

Please Help Members By Posting Answers For Below Questions

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

975

What is a covered index?

890

Can a function call a stored procedure in sql server?

909

How do I start and stop sql server?

965

Explain in details security in SQL azure?

121

what is the main function of a query parameter?

140

How do you create type- insensitive operator?

994

What is trigger explain with program?

931

What is the beast way to write CTE in SQL Server ?

981

How can we delete a table in sql server?

922

How many null values we can have in a unique key field in sql server?

903

What is plan freezing?

909

What is store procedure? How do they work?

953

How can you list all the columns in a database?

885

Can binary strings be converted into numeric or float data types?

967