A、Select * From Emp
B、Select * From Emp Where EmpNO Like '%%'
C、Select * From Emp Where Name = '%%'
D、Select * From Emp Where Name Like '%%'
更多“数据库中有一张表名为Emp，包含有如下列：EmpNO（雇员编号，Varchar（20），Pk），Job（职位Varchar（10）），HirDate（雇佣日期，Date），Sal（月薪，Float）。要求查询全部雇员信息应该是哪些数据？（）”相关的问题
A、Select *From Emp Where Job>="办事员" B、Select* From Emp Where Job==’办事员’ C、Select* From Emp Where Job<>’办事员’ D、Select* From Emp Where Job!=’办事员’
A、elect * From Emp Where HirDate>='1981-1-1' And HirDate <='1981-12-31' B、Select * From Emp Where Between In '1981-1-1' And <'1981-12-31' C、Select * From Emp Where Between In '1981-12-31' And <'1981-1-1' D、Select * From Emp Where HirDate>='1981-1-1' NOT HirDate <='1981-12-31'
A、A.Select * From Emp Where EmpNO In('791','792','793') B、B.Select * From Emp Where EmpNO ='791' Or EmpNO='792' OR EmpNO='793' C、C.Select * From Emp Where EmpNO >='791' And EmpNO<='793' D、D.Select * From Emp Where EmpNO >'791' And EmpNO<'793'
A、Select * From Emp Where EmpNO Not In('791','792','793') B、Select * From Emp Where EmpNO !='791' AND EmpNO!='792' And EmpNO='793' C、Select * From Emp Where EmpNO <>'791' AND EmpNO<>792' And EmpNO=<>793' D、Select * From Emp Where EmpNO =!'791' AND EmpNO =!'792' And EmpNO =!'793'
A、Select* From Student B、Select Name From Student C、Select Name，Age，IDCard From Student D、Select Name，Age，IDCard，Sex From Student
A、Select Count（1）From Student B、Select Sum（*）From Student C、Selec tAvg（*）From Student D、Select Count（*）From Student
A、Select*FromStudentWhereSex=’男’ B、Select*FromStudentWhereSex<>’女’ C、Select*FromStudentWhereSexLike’男’ D、Select*FromStudentWhereSexIn’男’
A、表是表空间的基础，表空间是所有相关表所占空间的总和 B、表空间是由一至多个数据文件构成的，每个表占用一个数据文件 C、一张表可以占用多个表空间，一个表空间也可以容纳多张表 D、一个表空间可以容纳多张表，但一张表只能归属于一个表空间 E、一个空数据库是不占用表空间的
客服
TOP
查看正确答案
