Blog Home  Home Feed your aggregator (RSS 2.0)  
Software Code Help - Find the fifth highest salary in Salary Table.
Blog
 
# Thursday, July 09, 2009
SELECT MIN(Salary) AS Expr1 FROM tblEmployee 
WHERE (empid IN (SELECT DISTINCT TOP 5 empid FROM tblSalary ORDER BY Salary))  
Thursday, July 09, 2009 7:27:51 AM (GMT Daylight Time, UTC+01:00)  #    Comments [0]   Interview Question SQL  | 
Comments are closed.
Copyright © 2010 SoftwareCodeHelp. All rights reserved.
DasBlog 'Portal' theme by Johnny Hughes.
Pick a theme: