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 choose all records from the table?

1000

What is it unwise to create wide clustered index keys?

957

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

992

between cast and convert which function would you prefer and why?

917

Explain tablesample?

948

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

892

What are indexers?

1037

What are difference between Cluster index and Non-Cluster index?

1022

Â Explain what is sql override for a source taLle in a mapping?

947

How to generate create table script on an existing table in ms sql server?

1094

How to override dml statements with triggers?

1072

What are information schema views?

924

How does recursive cte works in sql server?

942

What is sql server replication? : sql server replication

925

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

147