---

Exhibit: Examine the data in the EMPLOYEES table. Examine the subquery: SELECT last_name FROM employees WHERE salary IN (SELECT MAX(salary) FROM employees GROUP BY department_id); Which statement is true?（）
A:The SELECT statement is syntactically accurate.
B:The SELECT statement does not work because there is no HAVING clause.
C:The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
D:The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.

---

出自：Oracle认证

显示答案