首页 > 试题广场 >

Which statement shows the maxi

[单选题]

Which statement shows the maximum salary paid in each job category of each department?_______

select dept_id, job_cat,max(salary) from employees where salary > max(salary);

select dept_id, job_cat,max(salary) from employees group by dept_id,job_cat;

select dept_id, job_cat,max(salary) from employees;

select dept_id, job_cat,max(salary) from employees group by dept_id;

select dept_id, job_cat,max(salary) from employees group by dept_id,job_cat,salary;

漓江水

我感觉应该是B吧，每个部门每个工种的最高薪水，没必要再对薪水分组

发表于 2017-03-09 11:14:53 回复(0)

Rolandderest

答案选择E

题目要求确定各个部门薪资最高的工种，因而需要对dept_id,job_cat,salary进行分组。

发表于 2017-02-22 10:37:51 回复(0)

提交观点

问题信息

数据库

上传者：牛100

难度：

2条回答 2收藏 1430浏览

扫一扫，把题目装进口袋