Select * From Emp Where HirDate>='1981-1-1' And HirDate <='1981-12-31'< /div>
【单选题】数据库中有一张表名为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!='办事员'