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
答案解析:有
微信扫一扫手机做题