---

Examine the description of the EMPLOYEES table: Which statement shows the maximum salary paid in each job category of each department?（）
A:SELECT dept_id, job_cat, MAX(salary)   FROM employees   WHERE salary > MAX(salary);
B:SELECT dept_id, job_cat, MAX(salary)   FROM employees   GROUP BY dept_id, job_cat;
C:SELECT dept_id, job_cat, MAX(salary)   FROM employees;
D:SELECT dept_id, job_cat, MAX(salary)   FROM employees   GROUP BY dept_id;
E:SELECT dept_id, job_cat, MAX(salary)   FROM employees   GROUP BY dept_id, job_cat, salary;

---

出自：Oracle认证

显示答案