please tell me the query to get details of the employee
having the second largest salary
- 11 Answers
- 12491 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / rathi
If we had a table named Employee which had a column named
Salary and we had to find the second highest Salary in the
Employee table, the query for the same would be:
SELECT TOP 1 Salary FROM (SELECT TOP 2 Salary FROM Employee
ORDER BY Salary DESC) AS E ORDER BY Salary ASC
The subquery or the inner query would return the top 2 rows
in descending Salary order which would be:
5000
4000
The outer query would then select the top 1 row from the
subquery results in ascending Salary order which would be:
4000
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is default port number for sql server 2000?
What is an example of a foreign key?
What are the basic functions for master, msdb, model, tempdb databases?
How can we migrate from SQL server to SQL Azure?
what are cursors? : Sql server database administration
Can sql server 2016 run on windows 7?
What are partitioned views and distributed partitioned views?
Why use identity in sql server?
How to get the definition of a view out of the sql server?
Why do we use trigger?
What is raid, and how it can influence database performance?
What is transaction server auto commit?
query processing
How to view the error log for any specific instance? : sql server database administration
what is a live lock? : Sql server database administration
