试题详情
- 多项选择题 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));
关注下方微信公众号,在线模考后查看

热门试题
- The ORDERS table ha
- Which /SQL*Plus feat
- Examine the structu
- Which SQL statement
- Examine the statemen
- Which SQL statement
- Which /SQL*Plus feat
- Which two statements
- Evaluate the SQL sta
- Which SQL statement
- The EMPLOYEES table
- In which scenario wo
- What does the FORCE
- What is true about u
- Examine the structu
- Which three statemen
- You define a multipl
- You need to calculat
- ClicktheExhibitbutto
- Which two tasks can