select * from employee2 e where 2=(select count(distinct salary) from emplo

write the query for find the top 2 highest salary in sql
server

Question Posted / nilesh

Answer Posted / nilesh

select * from employee2 e where 2=(select count(distinct salary) from employee2
where e.salary<=salary)

Its working.

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How you can move data or databases between servers and databases in sql server?

1002

What is a full text index?

871

How to update muliple row in single query?

1000

What are the two authentication modes in sql server?

1058

How do I save a stored procedure in sql server?

929

In which files does sql server actually store data?

852

What do you understand by intent locks?

955

How to make a column nullable?

1038

Does sql server 2000 clustering support load balancing?

904

How many databases can we create in a single server?

205

How to verify a login name with sqlcmd tool?

1136

Why people hate cursor?

1096

What is the name of the Database which IBM mainframe uses?

947

What is Lock table in SQL?

1410

What is 2nf example?

941