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

Oracle认证考试

题库首页>其他计算机考试>Oracle认证考试

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));
查看答案

微信扫一扫手机做题