如何从Server表中获得最高薪资

Question

如何在Server中从表中获得第七高的薪资？

我试过这个：

SELECT max(salary)
FROM emptable
WHERE salary < (SELECT max(salary)
                FROM emptable);

Answer 1

SELECT salary
FROM   (
            SELECT salary
            ,      DENSE_RANK()OVER(ORDER BY salary) DR
            FROM emptable
       ) T
WHERE  T.DR = 7

Answer 2

从Server 2012及以后：

SELECT DISTINCT salary
FROM emptable
ORDER BY salary
OFFSET 6 ROWS
FETCH NEXT 1 ROWS ONLY;

Answer 3

你可以如下所示：

SELECT MAX(salary) 
FROM (SELECT DISTINCT TOP 7 salary FROM emptable ORDER BY salary) A