or if u want 2nd highest then write this query select Top 1 salary from

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

Question Posted / suhail qaiser

36 Answers
72790 Views
Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
E-Mail Answers

Answer Posted / suhail qaiser

or if u want 2nd highest then write this query

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 ?

29 Yes

24 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is rs.exe utility?

150

What is a transactions?

971

What are commonly used mssql functions in php?

998

What xml support does the sql server extend?

955

List types of tables in SQL Azure?

126

Is sql server difficult to learn?

863

Explain what are the database objects? : SQL Server Architecture

1004

How to use union to merge outputs from two queries together in ms sql server?

1006

What are information schema views?

921

What are the differences between stored procedure and view in sql server?

1158

Mention the 3 ways to get a count of the number of records in a table.

917

Define magic tables in sql server?

988

Explain what stored procedure sp_replcounters is used for? : sql server replication

1452

What are alternate keys?

934

When multiple after triggers are attached to sql table, how to control the order of execution?

977