单选题
在学生表STUD中,查询既不是信息系“IS”、数学系“MA”,也不是计算机系“CS”的学生的姓名(XM)和性别(XB)。实现该功能的正确SQL语句是______。
- A. SELECT XM.XB FROM STUD WHERE SD IN ("IS","MA","CS")
- B. SELECT XM.XB FROM STID WHERE SD NOT IN("IS","MA","CS")
- C. SELECT XM.XB FROM STUD WHERE SD NOT("IS","MA","CS")
- D. SELECT XM.XB FROM STUD WHERE SD NOT IN (IS,MA,CS)