Friday, 31 October 2014

Get Third Highest Salary Sql Query


Get Third Highest Salary 


SELECT TOP (1) * FROM
   (SELECT TOP (3) Empsalary FROM employeeMaster ORDER BY empsalary DESC) T
ORDER BY empsalary ASC

No comments:

Post a Comment

Thanks

SQL server tricky questions