程序员开发人员试题.pdfVIP

1、哪一个SQL有错误？ 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. 没有一个错误，都是对的. 2、两张表结构如下： EMPLOYEES （EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE ） NEW_EMPLOYEES （ EMPLOYEE_ID NUMBER Primary Key