【单选题】数据库中有一张表名为Emp,包含有如下列:EmpNO(雇员编号,Varchar(20),Pk),Job(职位Varchar(10)),HirDate(雇佣日期,Date),Sal(月薪,Float),Comm(奖金,Float,可为空)。Bank表,有如下列:BankNo(Int,自增长列,Pk),EmpNO(Varchar(20),Fk,关联EMP表),Bankcard(Varchar(19),...
A.
Select * From Emp Where EmpNO IN(Select EmpNO From Bank)
B.
Select * From Emp Where EmpNO Not IN(Select EmpNO From Bank)
C.
Select * From Emp Where EmpNO =(Select EmpNO From Bank)
D.
Select * From Emp Where EmpNO Not IN(Select * From Bank)