当前位置: 答题翼 > 问答 > 计算机类考试 > 正文
目录: 标题| 题干| 答案| 搜索| 相关
问题

Click the Exhibit button and examine the data in the EMPLOYEES table.Which three subqueries work? ()


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));

参考答案
您可能感兴趣的试题
  • Click the button “buy” or “add to my shopping cart” to continue shopping other items or check out. ()

  • He (按下)the button and the doorbell rang.

  • Click the Exhibit button. What two must the programmer do to correct the compilation errors? ()

  • Click the Exhibit button and examine the data from the EMP table.The COMMISSION column sho

  • Click the Exhibit button.Based on the exhibit client PC 192.168.10.10 cannot ping 1.1.1.2.Which is a potential cause for this problem?()

  • Click on the Exhibit button. Which of the following connectors is image D?()