摘要:
存在测试IN、NOT IN、EXISTS、NOT EXISTS例:SELECT * FROM SC WHERE SNO IN(SELECT SNO FROM STUDENT WHERE SSEX=’女’);同:SELECT * FROM SC WHERE EXISTS(SELECT * FROM STUDENT WHERE SSEX=’女’ AND SC.SNO=SNO);返回所有女生的成绩例:SELECT * FROM SC WHERE SNO NOT IN (SELECT SNO FROM STUDENT WHERE SSEX=’女’);同:SELECT * FROM SC WHERE N 阅读全文