问题 多项选择题

数据库中有一张表名为Emp,包含有如下列:EmpNO(雇员编号,Varchar(20),Pk),Job(职位Varchar(10)),HirDate(雇佣日期,Date),Sal(月薪,Float)。查询出受雇于1981年的雇员信息是()

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, B, C

单项选择题
单项选择题