## HAVING谓词 假设现在要求一个毕业生工资表中人数最多的人拿到的工资，可以使用如下语句 ~~~ SELECT income, COUNT(*) AS cnt FROM Graduates GROUP BY income HAVING COUNT(*) >= ALL (SELECT COUNT(*) FROM Graduates GROUP BY income); ~~~