select min(salary) from (select top 2 salary from emp order by salary desc

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

Question Posted / mohan c v

Answer Posted / mohan c v

select min(salary) from
(select top 2 salary from emp order by salary desc) as a

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sub query and its properties?

943

how many clustered indexes can be created on a table? : Sql server database administration

1099

Explain the difference between primary keys and foreign keys?

972

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

1017

What is msdb database? : SQL Server Architecture

1091

Explain forward - only cursors?

1012

How to create function with parameter in sql server?

1060

What is 2nf in normalization?

966

define and explain the differences between clustered and non-clustered indexes.

1148

What do we have to check in database testing?

983

What are the difference between primary key and unique key? : sql server database administration

917

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

1141

How to replace given values with null using nullif()?

948

What is normalization and its types?

983

What program is used to store the data source file?

925