单选题

Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHARD2(30) SALARY NUMBER(8,2) Which statement shows the maximum salary paid in each job category of each department? ()

ASELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX (salary);

BSELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id,job_cat;

CSELECT dept_id, job_cat, MAX(salary) FROM employees;

DSELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;

ESELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept _ id job _ cat salary;

正确答案

来源:www.examk.com

答案解析