select Top 1 salary from ( select top 2 salary from emp

write the query for find the top 2 highest salary in sql
server

Question Posted / santosh kumar

Answer Posted / santosh kumar

select Top 1 salary from ( select top 2 salary from
emp_table order by salary desc)temptable order by salary
asc.

Is This Answer Correct ?

11 Yes

12 No

Please Help Members By Posting Answers For Below Questions

What it means to be triggered?

1014

What is difference between foreign key and unique key?

1017

Does windows server 2016 come with sql server?

939

When you should use a low fill factor?

996

How to name query output columns in ms sql server?

970

What is Transparent Data Encryption?

1008

What are the five major components of a dbms?

932

Why are views required in the sql server or in any other database?

967

What is sql server programming?

1048

What is the cartesian product of the table?

958

Does union all remove duplicates?

1072

Explain Capacity planning to create a database? and how to monitor it?

4207

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1213

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1153

Call by value and call by reference in procedure and function, with NOCOPY.

1309