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

What is the native system stored procedure to execute a command against all databases?

1085

Why use update_statistics command in sql server?

1112

How many types of stored procedures are there in sql server?

1056

What is optimization and its types?

1037

How to implement service broker?

1069

What are the restrictions that views have to follow?

1029

List the types of recovery model available in sql server?

970

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1114

What are the encryption mechanisms in sql server?

1079

What is the difference between Triggers and Stored Procedure?

1152

How do you troubleshoot errors in a SQL Server Agent Job?

1104

What is log in sql server?

1201

What have included columns when we talk about sql server indexing?

1074

How to get a list of columns in a view using the "sp_help" stored procedure?

1087

How to apply cascading referential integrity in place of triggers?

1088