---

Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）
A:SELECT*FROMemp_dept_vu；
B:SELECTdepartment_id，SUM（salary）FROMemp_dept_vuGROUPBYdepartment_id；
C:SELECTdepartment_id，job_id，AVG（salary）FROMemp_dept_vuGROUPBYdepartment_id，job_id；
D:SELECTjob_id，SUM（salary）FROMemp_dept_vuWHEREdepartment_idIN（10，20）GROUPBYjob_idHAVINGSUM（salary）>；20000；
E:Noneofthestatementsproduceanerror；allarevalid

---

出自：Oracle认证

显示答案