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 advantage data architect?

920

Can we perform backup restore operation on tempdb? : sql server database administration

992

How do you identify a foreign key?

1021

How we can compare two database data?

940

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1119

What are xml indexes?

947

What is the order by used for?

1018

Are all views updatable ?

1149

Please differentiate between a local and a global temporary table?

1003

What is perspective, have you ever created perspective? : sql server analysis services, ssas

911

How to select all columns of all rows from a table with a select statement in ms sql server?

1111

What is clr ddl trigger?

958

What is temporary table in sql server? Why we use temp table?

949

Name and describe few console utilities for ssrs?

284

How to drop existing indexes in ms sql server?

1070