【多选题】
A SELECT DEPARTMENT_ID, MAX(SALARY) FROM EMPLOYEES GROUP BY SALARY HAVING MAX(SALARY) }> 10000
B SELECT DEPARTMENT_ID, MAX(SALARY) FROM EMPLOYEES GROUP BY SALARY WHERE MAX(SALARY) }> 10000
C SELECT DEPARTMENT_ID, MAX(SALARY) FROM EMPLOYEES GROUP BY SALARY ON MAX(SALARY) }> 10000
D SELECT DEPARTMENT_ID, MAX(SALARY) FROM EMPLOYEES WHERE MAX(SALARY) }> 10000 GROUP BY SALARY
查看更多