第6题
能正确查询出“没有选修课程编号为'C02'和'C04'这两门课的学生的学号和姓名“的选项有()。
A.SELECT SNO,SN FROM S WHERE SNO NOT IN (SELECT SNO FROM SC WHERE CNO='C02' OR CNO='C04');###SXB###B.SELECT SNO,SN FROM S WHERE NOT EXISTS (SELECT * FROM SC WHERE (CNO='C02' OR CNO='C04') AND SC.SNO=S.SNO);###SXB###C.SELECT SNO,SN FROM S WHERE NOT EXISTS(SELECT * FROM SC WHERE CNO='C02' AND SC.SNO=S.SNO) AND NOT EXISTS (SELECT * FROM SC WHERE CNO='C04' AND SC.SNO=S.SNO);###SXB###D.SELECT DISTINCT S.SNO,SN FROM S,SC WHERE SC.SNO=S.SNO AND CNO<&
点击查看答案