题目内容

Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... 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))

查看答案
更多问题

当两轴线()时,可采用蜗杆传动。

A. 平行
B. 相交
C. 垂直交错

非法客运当事人逃避处罚或者其他客观原因无法联系的,交通行政执法机构按照有关规定公告送达后,可以依法将暂扣车辆予以()。

A. 报废
B. 扣留
C. 拍卖

用绞车回撤托梁、回柱时,下列说法正确的是()

A. 清理杂物和移动障碍物,确保绳道畅通
B. 连接小链必须用安全可靠的马蹄环
C. 绞车不得全速运行,必须点动低速开启
D. 严格执行“拉活不拉死&rdquo

660能否实现小网管写IP,由下列选项哪一位决定()

A. K1.1
B. K1.2
C. K1.3
D. K1.4

答案查题题库