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

What is normalization and what are the advantages of it?

943

What are scheduled tasks in sql server?

1035

What are unicode character string data types in ms sql server?

1173

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

952

What is the index requirement in SQL Azure?

How to use clusters?

901

How do I completely remove sql server instance?

1044

What is SQL Azure?

105

Give an example of SQL injection attack ?

957

What is page-level compression?

925

Can we insert data if clustered index is disabled?

904

Tell me about pre-defined functions of sql?

1083

what are the reporting service components in SSRS?

157

Who developed sql server?

898

What are the diifferences between the ms sql server vs mysql?

1139