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 are transactions in sql?

987

What is the difference between writing data to mirrored drives versus raid5 drives

873

What is postgresql server?

943

What is the difference between Normalization and De-normalization?

1031

What is inner join? Explain with an example?

1120

What are different types of statements that are supported by sql?

985

what is database replicaion? : Sql server database administration

1106

What is a trace frag?

1036

What is Command line parameters in PLSQL.?

1062

What is explicit cursors?

991

What is the beast way to write CTE in SQL Server ?

986

What are the different types of upgrades that can be performed in sql server?

1120

What is change data capture (cdc) feature?

1000

How efficient you are in oracle and SQL server?

1091

What is RAID? What are the different types of RAID configurations?

1066