数据库中有一张表名为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
答案解析:有

微信扫一扫手机做题