SELECT MAX(Salary) FROM Employees WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employees ) select top 5 salary from Employees;
SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP n salary FROM employees ORDER BY salary DESC) a ORDER BY salary
SELECT DISTINCT TOP 5 salary FROM employees ORDER BY salary DESC
select distinct top 5 salary from employees order by salary desc
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)