当前位置: X题卡 > 所有题目 > 题目详情

在学生表STUD中,查询既不是信息系‘IS’、数学系‘MA’也不是计算机系'CS’的学生的姓名(XM)和性别(XB) 。SD为系名。实现该功能的正确SQL语句是______。

查看本题答案

你可能感兴趣的试题

SELECT XM,SA,SD FROM STUD   WHERE BETWEEN 20<SA<23;  SELECT XM,SA,SD FROM STUD   WHERE SA BETWEEN 23 AND 20  SELECT XM,SA,SDFROM STUD   WHERE SA NOT BETWEEN 20 AND 23  SELECT XM,SA,SDFROM STUD   WHERE SA BETWEEN 20 AND 23  
SELECT XM,XB FROM STUD WHERE SD IN('IS','MA','CS');  SELECT XM,XB FROM STUD WHERE SD NOT IN ('IS','MA','CS');  SELECT XM,XB FROM STUD WHERE SD NOT('IS','MA','CS');  SELECT XM,XB FROM STUD WHERE SD NOT IN(IS,MA,CS);  
SELECT XM,SA,SD FROM STUD WHERE BETWEEN 20SELECT XM,SA,SFROM STUD WHERE SA BETWEEN 23 AND 20  SELECT XM,SA,SD FROM STUD WHERE SA NOT BETWEEN 20 AND 23  SELECT XM,SA,SD FROM STUD WHERE SA BETWEEN 20 AND 23  
SELECT XM,XB FROM STUD WHERE SD IN('IS','MA','CS');  SELECT XM,XB FROM STUD WHERE SD NOT IN ('IS','MA','CS');  SELECT XM,XB FROM STUD WHERE SD NOT('IS','MA','CS');  SELECT XM,XB FROM STUD WHERE SD NOT IN(IS,MA,C;  
SELECT XM,XB FROM STUD WHERE SD IN("IS","MA","CS")  SELECT XM,XB FROM STUD WHERE SD NOT IN("IS","MA","CS")  SELECT XM,XB FROM STUD WHERE SD NOT("IS","MA","CS")  SELECT XM,XB FROM STUD WHERE SD NOT IN(IS,MA,C  
SELECTXM, SA, SD FROM STUD WHERE BETWEEN 20<SA<23  SELECTXM, SA, SD FROM STUD WHERE SA BETWEEN 23 AND 20  SELECTXM, SA, SD FROM STUD WHERE SA NOTBETWEEN20 AND 23  SELECTXM, SA, SD FROM STUD WHERE SA BETWEEN 20 AND 23  
SELECT XXB FROM STUD WHERE SD IN ("IS","MA","CS")  SELECT XXB FROM STID WHERE SD NOT IN("IS","MA","CS")  SELECT XXB FROM STUD WHERE SD NOT("IS","MA","CS")  SELECT XXB FROM STUD WHERE SD NOT IN (IS,MA,C  
SELECT*FROM STUD WHERE 姓名 LIKE"张%”  SELECT*FROM STUD WHERE 姓名 IN("张%")  SELECT*FROM STUD WHERE 姓名 LIKE"张$"  SELECT*FROM STUD WHERE 姓名 IN"张$)"  
SELECT XM, XB FROM STUD WHERE SD IN ('IS','MA','CS');  SELECT XM, XB FROM STUD WHERE SD NOT 1N ('IS','MA','CS');  SELECT XM, XB FROM STUD WHERE SD NOT ('IS','MA','CS')  SELECT XM, XB FROM STUD WHERE SD NOT IN (IS, MA, C;  
SELECT XM,XB FROM STUD WHERE SD IN("IS","MA","CS")  SELECT XM,XB FROM STUD WHERE SD NOT IN("IS","MA","CS")  SELECT XM,XB FROM STUD WHERE SD NOT("IS","MA","CS")  SELECT XM,XB FROM STUD WHERE SD NOT IN(IS,MA,CS)  
SELECTXM,XBFROMSTUDWHERESDIN('IS','MA','CS');  SELECTXM,XBFROMSTUDWHERESDNOTIN('IS','MA','CS');  SELECTXM,XBFROMSTUDWHERESDNOT('IS','MA','CS'):  SELECTXM,XBFROMSTUDWHERESDNOTIN(IS,MA,CS):  
SELECT XM,SA FROM STUD FOR SA<20  SELECT XM,SA FROM STUD WHERE NOT SA>=20  SELECT XM,SA ON STUD FOR SA<20  SELECT XM,SA ON STUD WHERE SA<20  
SELECT XM,XB FROM STUD WHERE SD IN ('IS','MA','CS');  SELECT XM,XB FROM STUD WHERE SDNOTIN ('IS','MA','CS');  SELECT XM,XB FROM STUD WHERE SD NOT ('IS','MA','CS');  SELECT XM,XB FROM STUD WHERE SD NOT IN (IS,MA,C;  
SELECT * FROM STUD WHERE 姓名LIKE“张%”  SELECT * FROM STUD WHERE 姓名IN(“张%”)  SELECT * FROM STUD WHERE 姓名LIKE“张$”  SELECT * FROM STUD WHERE 姓名IN(“张$)”  
SELECT XM,XB  FROM STUD  WHERE SD IN (’IS’,’MA’,’CS’);  SELECT XM,XB  FROM STUD  WHERE SDNOTIN (’IS’,’MA’,’CS’);  SELECT XM,XB  FROM STUD  WHERE SD NOT (’IS’,’MA’,’CS’);  SELECT XM,XB  FROM STUD  WHERE SD NOT IN (IS,MA,CS);  
SELECT XM.XB FROM STUD WHERE SD IN ("IS","MA","CS")  SELECT XM.XB FROM STID WHERE SD NOT IN("IS","MA","CS")  SELECT XM.XB FROM STUD WHERE SD NOT("IS","MA","CS")  SELECT XM.XB FROM STUD WHERE SD NOT IN (IS,MA,CS)  
SELECT XM, XB
FROM STUD
WHERE SD IN ('IS','MA','CS');  
SELECT XM, XB
FROM STUD
WHERE SD NOT 1N ('IS','MA','CS');  
SELECT XM, XB
FROM STUD
WHERE SD NOT ('IS','MA','CS')  
SELECT XM, XB
FROM STUD
WHERE SD NOT IN (IS, MA, CS);  

热门试题

更多