- 错误1:仅输出第一个记录,相当于HAVING 1;
SELECT *
FROM table
HAVING MAX(number)
- 错误2:语法错误,因为MAX(number)根本不会执行出结果
SELECT *
FROM table
HAVING number=MAX(number)
- 正确:
-
SELECT *
FROM employees
HAVING employees.hire_date=(SELECT MAX(employees.hire_date)FROM employees);