單項選擇題
數(shù)據(jù)庫中有一張表名為Emp,包含有如下列:EmpNO(雇員編號,Varchar(20),Pk),Job(職位Varchar(10)),HirDate(雇傭日期,Date),Sal(月薪,F(xiàn)loat)。查詢出受雇于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"