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

How is table type constraint applied to a table?

1030

What is GUID in sql server?

1226

Tell me what is the stuff and how does it differ from the replace function?

1035

What are the different normalization forms?

1165

What is the sql case statement used for?

1133

Why are sql functions used?

1185

What are click through reports?

149

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

1346

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1108

How to connect to a sql server using odbc_connect()?

1205

What is the difference between seek predicate and predicate?

1111

How many columns can we include on clustered index ?

1060

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1101

List the different normalization forms?

1023

What is the beast way to write CTE in SQL Server ?

1096