7-31.sql

SQL2000跟课件学习的源代码 分享共同学习

USE Educational
GO
SELECT  *
FROM  Grade  G
WHERE  EXISTS  ( /* 子查询: 030501班的并在Grade表中有成绩记录的学生 */
  SELECT  * 
  FROM Student  S
  WHERE  ClassID ='030501'  AND  StudentID = G.StudentID
  )