【单项选择题】
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<br /> JOB_ID VARCHAR2(20) From the EMPLOYEES table<br /> SALARY NUMBER From the EMPLOYEES table<br /> DEPARTMENT_ID NUMBER From the DEPARTMENTS table<br /> DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table<br /> Which SQL statement produces an error?（）<p> 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<br /> JOB_ID VARCHAR2(20) From the EMPLOYEES table<br /> SALARY NUMBER From the EMPLOYEES table<br /> DEPARTMENT_ID NUMBER From the DEPARTMENTS table<br /> DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table<br /> Which SQL statement produces an error?（）</p>
A、A. SELECT * FROM emp_dept_vu;
B、B. SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;
C、C. SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;
D、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、E. None of the statements produce an error; all are valid.
查看正确答案
