select min(salary) from (select top 2 salary from phani order by salary de

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 phani 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 key set driven?

907

What the different components in replication and what is their use?

932

What are the different acid properties?

1037

Explain various On-Delete options in a DB table. Which is the default option?

1428

Tell me what is log shipping?

955

Mention the differences between having and where clause.

1024

How many joins in sql server?

918

What are the difference between clustered and a non-clustered index?

997

What is difference between count (*) and count 1?

883

What are the requirements for sql server 2016?

868

How to create a Master database in SQL server ?

1048

How to create stored procedures with parameters in ms sql server?

1023

What is collation sensitivity? Explain different types.

979

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1104

What is the command used to check locks in microsoft sql server?

1000