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

how to avoid cursors? : Sql server database administration

1011

How to provide login information for a new odbc dsn?

1094

What is NOT NULL Constraint in sql server 2012?

1044

How can we delete a table in sql server?

1019

How to find the service pack installed? : sql server database administration

1062

how to create a scrollable cursor with the scroll option? : Sql server database administration

1144

What action plan is preferred if sql server is not responding?

1153

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

1034

Define the one-to-one relationship while designing tables.

937

What sql server means?

1004

What is the report builder?

143

Does sql server 2000 clustering support load balancing?

1024

How to write an inner join with the where clause in ms sql server?

1161

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1991

Why truncate is ddl?

1133