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

How to manipulate data from one table to another table ?

913

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

977

How do you identify a foreign key?

972

What are rest-style architecture's?

170

What are data driven subscriptions?

106

How to connect to SQL Azure Database by using sqlcmd?

136

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2449

What is the default value of an integer data type in sql server 2005?

912

What number aggregate functions are accessible there in sql?

1009

What is difference between drop truncate and delete?

1020

what is nonclustered index

901

Can a synonym name of a table be used instead of a table name in a select statement?

976

Does the unique constraint create an index?

991

What is a DBMS, query, SQL?

998

Where are sql server usernames and passwords stored in the sql server?

1045