多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题