单选题
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_ NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHAR2(30) SALARY NUMBER(8,2) Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only if the minimum salary is less than 5000 and maximum salary is more than 15000?（）
发布日期：2020-04-10
SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000;
SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000 GROUP BY dept_id;
SELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在
CMS专题
CMS专题
其他考试
下列历代帝王的陵墓中，不是以“方上”形式的是（ ）。
患儿，2岁。体重11kg。盛夏就诊，腹泻2天，量多次频，泻下急迫，大便呈黄色蛋花样，有少许黏液，精神稍差，皮肤弹性尚可，哭时有泪，尿黄量少。舌质红，苔黄腻，指纹紫。大便常规：WBC4～6／HP，RBC1～2／Hp。应首先考虑的诊断是（）
在完成项目活动定义以后，项目时间管理的下一个步骤就是（）。
关于远曲小管的叙述不正确的有（）
架空线FTU终端，只有本地保护功能，不能实现远程操控。
患者，男，28岁，患尿毒症晚期，拟接受肾移植手术。介导超急性排斥反应的主要物质是（）.
现代城市经济管理的主要任务是什么？
65.某次抽奖活动在三个箱子中均放有红.黄.一绿.蓝.紫.橙.白.黑8种颜色的球各一个，奖励规则如下：从三个箱子中分别摸出一个球，摸出的3个球均为红球的得一等奖，摸出的3个球中至少有一个绿球的得二等奖，摸出的3个球均为彩色球（黑.白除外）的得三等奖。问不中奖的概率是多少?（ ）
根据《流动人口计划生育工作条例》，流动人口在现居住地享受的计划生育服务和奖励包括( )。
眼内异物伤的治疗原则是（）。
暂无相关推荐~
Examine the description of the EMPLOYEES table: Which statement shows the depart...
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_N...
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_N...
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_N...
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_N...
Examine the description of the EMPLOYEES table: Which statement shows the maximu...
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_N...
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_ ...
Examine the description of the EMPLOYEES table: Which statement produces the num...
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_N...