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 is a with(nolock)?

980

What is filtered index?

1090

How to search for a string in all stored procedure in sql server?

996

What is shrink log file?

896

How you can find out if an index is useful to the optimizer?

936

Write a sql query to get zero records from a table having n number of records?

1177

What happens if you are trying to access a schema not owned by you?

966

Is sql server 2016 free?

935

Define Wed Edition in SQL Azure?

100

What is the difference between migration and upgradation in sql server?

1092

Explain the concepts and capabilities of sql server?

969

Explain alternate key, candidate key and composite key in sql server?

910

Can you force a query to use a specific index?

940

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1207

Explain iaas, paas and saas?