Examine the description of the EMPLOYEES table: Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and the maximum salary is more than 15000?()
A:SELECT dept_id, MIN(salary(, MAX(salary)   FROM employees   WHERE MIN(salary) < 5000 AND MAX(salary) > 15000;
B:SELECT dept_id, MIN(salary), MAX(salary)   FROM employees   WHERE MIN(salary) < 5000 AND MAX(salary) > 15000   GROUP BY dept_id;
C:SELECT dept_id, MIN(salary), MAX(salary)   FROM employees   HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
D:SELECT dept_id, MIN(salary), MAX(salary)   FROM employees   GROUP BY dept_id   HAVING MIN(salary) < 5000 AND MAX(salary) < 15000;
E:SELECT dept_id, MIN(salary), MAX(salary)   FROM employees   GROUP BY dept_id, salary   HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
出自:Oracle认证

完成拼图验证

按住下方滑块,将拼图拖到缺口处后松开。

拼图背景,将小拼图拖到缺口处
向右拖动滑块