1.2.34.sql

来自「清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码」· SQL 代码 · 共 13 行

SELECT X.SID
FROM CHOICES AS X,CHOICES AS Y
WHERE X.CID=(
       SELECT CID
       FROM COURSES
       WHERE CNAME='c++'
      ) AND X.SID=Y.SID AND NOT (
      Y.CID=(
             SELECT CID
             FROM COURSES
             WHERE CNAME='java'
)
)