Tuesday, 13 May 2014

Find Any Number Of Employee Salary ( Highest and Smallest) in Sql Server

Query :  Third Highest Employee Salary

select min(EmpSalary) from Employee where EmpSalary IN
(select Top 3 EmpSalary from Employee order by EmpSalary desc)



Query :  Third Smallest Employee Salary

select max(EmpSalary) from Employee where EmpSalary IN
(select Top 3 EmpSalary from Employee order by EmpSalary asc)

No comments:

Post a Comment