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 an example of a foreign key?

973

How many types of database relationship in sql server?

1052

What is filter index?

950

How to get a list all databases on the sql server?

1096

What is TDS(Tabular Data Stream) Gateway?

121

How to create hyperlink from returned sql query ?

1121

do views contain data ?

959

Do you know what is difference between index seek vs. Index scan?

954

What is temporal table?

883

What is normalization and its types?

1024

Explain trigger and trigger types?

964

what stored procedure would you use to view lock information? : Sql server administration

968

What are the hotfixes and patches in sql server?

1014

Explain the difference between control flow and data flow?

991

Does the unique constraint create an index?

1054