数据库中有一张表名为Emp,包含有如下列:EmpNO(雇员编号,Varchar(20),Pk),Job(职位Varchar(10)),HirDate(雇佣日期,Date),Sal(月薪,Float)。查询出受雇于1981年的雇员信息。
A.
Select * From Emp Where HirDate>='1981-1-1' And HirDate <='1981-12-31'
B.
Select * From Emp Where HirDate>'1981-1-1' And HirDate
C.
Select * From Emp Where HirDate>='1981-1-1' OR HirDate <='1981-12-31'
D.
Select * From Emp Where HirDate>='1981-1-1' NOT HirDate <='1981-12-31'