第二高的薪水
SELECT
IFNULL(
(SELECT DISTINCT Salary
FROM Employee
ORDER BY Salary DESC
LIMIT 1 , 1),
NULL) AS SecondHighestSalary
IFNULL(expression, alt_value)
expression:必须,要测试的值
alt_value:必须,expression 表达式为 NULL 时返回的值
第N高的薪水
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
set N=N-1;# 这一步一定不能丢
RETURN (
SELECT
salary
FROM
employee
GROUP BY
salary
ORDER BY
salary DESC
LIMIT N, 1
);
END
查找重复的电子邮箱
select Email from