阅读下面SQL语句: SELECT * FROM department WHERE did NOT IN(SELECT did FROM employee WHERE age=20); 下面对上述语句的描述中,正确的是()
A.查询存在年龄为20岁的员工的部门
B.查询年龄小于20岁的员工的部门
C.查询不存在年龄为20岁的员工的部门
D.查询年龄大于20岁的员工的部门
A.查询存在年龄为20岁的员工的部门
B.查询年龄小于20岁的员工的部门
C.查询不存在年龄为20岁的员工的部门
D.查询年龄大于20岁的员工的部门
第1题
A、查询年龄大于21的员工信息
B、查询存在年龄大于21的员工所对应的部门信息
C、查询存在年龄大于21的员工所对应的员工信息
D、查询存在年龄大于21的员工信息
第2题
A、采用了自连接查询
B、采用了普通交叉连接查询
C、存在语法错误,因为JOIN两边都是对同一个表操作
D、用于查询与王红不同一个部门的员工
第4题
A.Australia.
B.Japan.
C.Netherland.
D.England.
第5题
A.From a book.
B.She doesn't really know where they originated.
C.From her children.
D.From her families.
第6题
A.Australia.
B.Japan.
C.Netherland.
D.England.
第8题
A. In 28 states, from West Virginia in the east to Montana in the west.
B. In 27 states, from West Virginia in the west to Montana in the east.
C. In 27 states, from West Virginia in the east to Montana in the west.
D. In 28 states, from West Virginia in the west to Montana in the east.
第10题
A.In 28 states, from West Virginia in the east to Montana in the west.
B.In 27 states, from West Virginia in the west to Montana in the east.
C.In 27 states, from West Virginia in the east to Montana in the west.
D.In 28 states, from West Virginia in the west to Montana in the east.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!