试题详情
单项选择题 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;

  • B

  • 关注下方微信公众号，在线模考后查看

热门试题