6.2.2.sql

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

(1)
USE School
GO

SET SHOWPLAN_ALL ON
GO

SELECT * FROM TEACHERS
GO

SET SHOWPLAN_ALL OFF
GO

(2)

USE School
GO

SET SHOWPLAN_ALL ON
GO

SELECT sname FROM STUDENTS, CHOICES 
WHERE cid = '10010'
GO

SELECT sname FROM STUDENTS
WHERE sid IN (SELECT sid FROM CHOICES WHERE cid = '10010')
GO

SET SHOWPLAN_ALL OFF
GO