Thursday, June 19, 2014

Top One Salary and top 2 salary

TOP 1 

Select Top 1 Salary from (select top 1 salary from xxx order by salary desc) as salary order by salary asc

TOP 2

Select Top 1 Salary from (select top 2 salary from xxx order by salary desc) as salary order by salary asc

----
Note
WHERE XXX Is Table name