Home > IT Answers > SQL Server > Sql server 2005 – query
DotNetj
5 pts.
 Sql server 2005 – query
SQL Server 2005, SQL Server Query
How to write quary to calculate second highest salary in Emp Table using  "Top" Keyword

Software/Hardware used:
Sql Server 20005
ASKED: February 25, 2010  6:39 AM
UPDATED: February 25, 2010  5:14 PM
RELATED QUESTIONS
Answer Wiki:
<pre>select top 1 salary from Emp where salary not in (select top 1 salary from Emp order by salary desc) order by salary desc</pre> I would recommend you <a href="http://www.sql-ex.ru">sql-ex.ru/</a>.
Last Wiki Answer Submitted:  February 25, 2010  5:14 pm  by  msi77   1,610 pts.
All Answer Wiki Contributors:  msi77   1,610 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _