(多选题)
Examine the data in the EMPLOYEES table:
Which three subqueries work? ()
ASELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);
BSELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
CSELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
DSELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
ESELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
FSELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
正确答案
答案解析
略
![快考试在线搜题](http://static.examk.com/pc/images/qrcode.gif)