Click the Exhibit button and 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 AVG(SALARY));
正确答案:C,D,E
答案解析:有
微信扫一扫手机做题