Friday, February 28, 2014

Find Nth Highest Salary of Employee order by Desc

SELECT TOP 3 EmpSal
FROM (
SELECT DISTINCT TOP 3 EmpSal
FROM tblEmp1
ORDER BY EmpSal DESC) a
ORDER BY EmpSal

No comments:

Post a Comment

Generate All Database Backup From Sql Server Using Query

DECLARE   @name   VARCHAR ( 50 )   -- database name DECLARE   @path   VARCHAR ( 256 )   -- path for backup files DECLARE   @fileName  ...