Click the Exhibit button and 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认证

完成拼图验证

按住下方滑块,将拼图拖到缺口处后松开。

拼图背景,将小拼图拖到缺口处
向右拖动滑块