网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
Examine the data in the EMPLOYEES table:LAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 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));

参考答案

更多 “ Examine the data in the EMPLOYEES table:LAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 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)); ” 相关考题
考题 有以下程序#include stdio.hstruct st{ int x,y;} data[2]={1,10,2,20};main(){ struct st *p=data;printf("%d,",p-y); printf("%d\n",(++p)-x);}程序的运行结果是A)10,1B)20,1C)10,2D)20,2
查看答案
考题 在执行语句SELECT department_id FROM employees,departments WHERE employees.department_id= departments.department_id;时报错,原因是()。 A.没有给表employees和表departments加别名B.没有给列department_id加别名C.不能用employees.department_id=departments.department_id作为条件D.SELECT后面的department_id没有指定是哪个表
查看答案
考题 有以下程序：struct s{ int x,y; }data[2]={10,100,20,200};main(){ struct s *p=data;printf("%d\n",(++p)-x);}程序运行后的输出结果是（ ）。A．10 B．11 C．20 D．21
查看答案
考题 执行下列程序段后，DATA1单元的值为( ) DATA1 DB 10H，20H DATA2 DB 30H，40H MOV AX，WORD PTR DATA1 CMP AX，WORD PTR DATA2 JA L MOV BX，WORD PTR DATA2 MOV WORD PTR DATA2，AX MOV WORD PTR DATA1，BX L：HLTA．40HB．30HC．20HD．10H
查看答案
考题 有以下程序}struct s{ int x,y; } data[2]={10,100,20,200};}main( )}{ struct s *p=data;}printf("%d\n",++(p-＞x));}程序运行后的输出结果是A．10B．11C．20D．21
查看答案
考题 在SQL Server 2000中，现要在employees表的first_name和last_name列上建立一个唯一的非聚集复合索引，其中first_name列数据的重复率是5%，last_name列数据的重复率是10%。请补全下列语句使以first_name和last_name列作为条件的查询效率最高。CREATE UNIQUE NONCLUSTERED INDEX Idx_NameON employees(______)
查看答案
考题 有以下程序 struct s {int x,y;}data[2]={10,100,20,200}； main() { struct s*p=data； printf("%d\n"，++(p-＞x))； } 程序运行后的输出结果是A．10B．11C．20D．21
查看答案
考题 有以下程序： struct s { int x,y;) data[2]={10,100,20,200); main() { struct s *p=data; printf("%d\n",++(p-＞x)); } 程序运行后的输出结果是( )。A．10B．11C．20D．21
查看答案
考题 有以下程序 struct s { int x,y; } data[2]={10,100,20,200}; main() struct s *p=data; printf("%d\n",++(p-＞x)); 程序运行后的输出结果是A．10B．11C．20D．21
查看答案
考题 以下C语言程序的输出结果是（ ）。struct s{int x,y;}data[2]={10,100,20,200};main（ ）{struct s*p=data;p++;printf（“%d\n”,++（p->x））;}A.10 B.11 C.20 D.21
查看答案
热门标签
最新试卷