题目内容
(请给出正确答案)
[多选]
在SQLServer中,下面的语句执行时不会出现错误的有()
A、SELECTename,job,salFROMEMPWHEREdeptnoALL(SELECTdeptnoFROMdeptWHEREdnameLIKE‘A%’)
B、SELECTename,job,salFROMEMPWHEREdeptno=ANY(SELECTdeptnoFROMdeptWHEREdnameLIKE‘A%’)
C、SELECTename,job,salFROMEMPWHEREdeptnoANY(SELECTdeptnoFROMdeptWHEREdnameLIKE‘A%’)
D、SELECTename,job,salFROMEMPWHEREdeptnoIN(SELECTdeptnoFROMdeptWHEREdnameLIKE‘A%’)
查看答案