【单选题】
Examine the structure of the EMP_DEPT_VU view:<br /> Column Name Type Remarks<br /> EMPLOYEE_ID NUMBER From the EMPLOYEES table<br /> EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table<br /> SALARY NUMBER From the EMPLOYEES table<br /> DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）
A、SELECT * FROM emp_dept_vu;
B、SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;
C、SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;
D、SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) > 20000
E、None of the statements produce an error; all are valid.
查看正确答案
