我如何从员工表中找到第二高的薪水?

分类: 技术问答 • 2022-03-10 20:25:12

问题描述：

我该如何查询Employee表中所有雇员的第二大薪水?

How would I go about querying for the second largest salary from all employees in my Employee table?

答

尝试一下:

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