శాలరీ ఇన్ ఎనీ పోసిషన్ ...

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 6 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

You can change and use it for getting nth highest salary from Employee table as follows

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
where n > 1 (n is always greater than one)


Select MAX(Salary) from ggg where Salary <> (Select MAX(Salary) from ggg)

select top 1 salary from ggg where salary<(select max(salary) from ggg)
order by salary desc

SELECT MAX(E1.salary) FROM ggg E1 ggg E2
WHERE E1.salary< E2.salary



SELECT MIN(Sal) FROM TableName
WHERE Sal IN
(SELECT TOP 4 Sal FROM TableName ORDER BY Sal DESC)