问题:
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
Examine the description of the EMPLOYEES table:
Which statement shows the maximum salary paid in each job category of each department?()
● 参考解析
本题暂无解析
相关内容
相关标签