write the query for find the top 2 highest salary in sql
server
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 |
Post New Answer View All Answers
What is a with(nolock)?
What is filtered index?
How to search for a string in all stored procedure in sql server?
What is shrink log file?
How you can find out if an index is useful to the optimizer?
Write a sql query to get zero records from a table having n number of records?
What happens if you are trying to access a schema not owned by you?
Is sql server 2016 free?
Define Wed Edition in SQL Azure?
What is the difference between migration and upgradation in sql server?
Explain the concepts and capabilities of sql server?
Explain alternate key, candidate key and composite key in sql server?
Can you force a query to use a specific index?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
Explain iaas, paas and saas?