多选题Click the Exhibit button and 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 AVG(SALARY));
多选题
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));
参考解析
解析:
暂无解析
相关考题:
单选题下列不属于“隧道照明控制系统的功能”的选项是()。A合理地设置隧道照明系统能避免隧道黑洞效应,保证行车安全B养护工作所需照明C并根据洞外的照度变化、交通量的变化对洞内照明强度进行调节D节约用电,降低运营费用
单选题What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?()A It improves resync operations.B This feature enables much faster file opens.C It improves performance as fewer extent pointers are needed in the shared pool.D It improves performance by reading from a copy of an extent closest to the node.
单选题课堂上有位学生指出老师对某个问题的解释有错误,老师当时就恼怒起来:“某某同学,算你厉害,老师不如你,以后老师的课就由你来上好了!”全班同学随老师一起嘲笑这位学生,该生从此在课堂不能发现问题,也不主动回答问题了。教师威信的核心是( )。A权力威信B信服威信C职业威信D能力威信
多选题海内外旅游者外出旅游应随身携带表明本人身份的证件。下列选项中,不正确的有()。A来我国内地旅游的外国公民应持有外国护照和中国签证B华侨使用回乡证C台湾同胞应持有《台湾居民来往内地通行证》D港澳居民应持有《港澳居民来往内地通行证》E我国内地居民出境旅游应持有《中华人民共和国居民身份证》
多选题关于智能天线技术描述正确的包括()A智能天线能够提高基站接收灵敏度,增加基站覆盖距离;B智能天线能实现单基站用户定位,终端不需要GPS;C只有定向天线阵能使用智能天线,全向天线阵无法使用智能天线技术;D即使用户集中在一个方向上,智能天线也能实现用户的精确定位;
单选题金融企业代理证券发行单位发行证券,如果在发行期内金融企业代理发行的证券未全部售出,则剩余部分由金融企业购人。这种代理发行方式属于()。A代销方式B全额承购包销方式C余额承购包销方式D购人证券方式
单选题依据以下条件,请你判断符合这些条件的历史人物是①文艺复兴时期德意志人文主义代表②他是16世纪杰出的以考订基督教经典而出名的思想家③他对教士的愚昧、教皇的贪婪进行了深刻的揭露和辛辣的讽刺()A马基雅维利B伊拉斯谟C拉伯雷D塞万提斯
单选题下列哪一项不属于执法的原则()。A合法性原则B程序性原则C合理性原则D效率性原则