select distinct top 2 salary from employee order by salary desc

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

Question Posted / saravanan p

Answer Posted / saravanan p

select distinct top 2 salary from employee order by salary
desc

Is This Answer Correct ?

6 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is bcp? When does it use?

940

Can another user execute your local temporary stored procedures?

981

What is b tree index?

911

What is coalesce in sql server?

1048

Explain what is public role in sql server?

1119

Explain query editor regions

1039

What are data regions?

135

What are “lost updates”?

989

Ms sql server index?

1060

What is similarity and difference between truncate and delete in sql?

1096

What are different types of raid configurations? : SQL Server Architecture

1069

What is a unique key constraint?

1024

Tell me can we use custom code in ssrs?

997

What is default constraint in ms sql server?

1026

What are the filtered indexes?

1035