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

What are the transaction properties?

1028

What is the full form of ddl?

932

What are the general features of sql server management studio? : sql server management studio

1088

Can a trigger be created on a view?

964

How to copy the tables, schema and views from one sql server to another?

1055

What is the use of keyword with encryption. Create a store procedure with encryption?

969

Why is normalisation important?

953

When would you prefer to have a minimum number of indexes?

913

What are the underflow and overflow behaviors on float literals?

1118

What is raid, and how it can influence database performance?

1066

Explain what role entity and relationship play in an ER diagram.

1080

What is field in algebra?

1047

What is isnull() operator?

1050

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1091

How to check if stored procedure is running in sql server?

1070