SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 2 salary FROM employee ORDE

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

Question Posted / ram murthy

Answer Posted / ram murthy

SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 2 salary FROM
employee ORDER BY salary DESC) a ORDER BY salary

Is This Answer Correct ?

3 Yes

4 No

Please Help Members By Posting Answers For Below Questions

what method you can use to reduce the overhead of Reporting Services data sources?

268

State the difference between union and union all?

985

What are different types of replication in sql server?

1144

If user is owning any SQL Objects, can we drop that user

2131

Give me any three differences between Truncate and Delete.

1156

Write a sql query to delete duplicate records from a table called table1

1088

How to delete existing triggers using "drop trigger"?

1098

Why do we use non clustered index?

1132

What are different backups available in sql server?

1153

Does sql server use t sql?

1071

What is candidate key with example?

1031

Can we create clustered index on composite key?

1168

Explain the flow of creating a cube? : sql server analysis services, ssas

1100

What are orphan records?

986

How to send email from database?

1071