试题详情
多项选择题 Examine the data in the EMPLOYEES table: Which three subqueries work? ()

A、SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);

B、SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);

C、SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);

D、SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);

E、SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);

F、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));

  • C,D,E
  • 关注下方微信公众号,在线模考后查看

热门试题