1.2.29.sql

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

SELECT SNAME
FROM STUDENTS
WHERE NOT EXISTS
(SELECT *
 FROM CHOICES AS X
 WHERE NOT EXISTS
  (SELECT *
   FROM CHOICES AS Y
   WHERE Y.SID=STUDENTS.SID AND Y.CID=X.CID
  )
)