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 is use of @@ spid in sql server?

1264

Explain what is sql server english query?

1107

What is the cartesian product of table?

1060

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

1030

Explain “row_number()” in sql server with an example?

1053

How to deploy the Report?

140

Detail about the hardware which is supported by SQL server?

1115

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1108

When we should use @@error?

1030

Introduction of rollup clause using sum and group by clause?

1009

What is the difference between Clustered and Non-Clustered Index?

1100

What is etl - extraction, transformation, and loading?

958

What is nolock hint in sql server 2008

1178

Can sql servers linked to other servers like oracle?

1006

What are commit and rollback in sql?

1168