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 catalog views?

1031

What is t-sql script to take database offline – take database online.

1033

What is exporting and importing utility?

1030

Explain stored procedure?

1001

What is the contrast between sql and mysql?

1056

How do I setup a sql server database?

1021

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

959

What is the difference between nvl and nvl2?

905

Explain log shipping?

972

We need to perform what steps in the following order to work with a cursor?

1180

What is the maximum size of column in sql server?

863

How many non clustered indexes there can be on table ?

871

What is the correct order of the logical query processing phases?

887

What are the general features of sql server management studio? : sql server management studio

1034

What types of Joins are possible with Sql Server?

1077