针对S_T数据库,查询选修了3号课程但没有选修1号课程的学生。
SELECT [sno]
FROM [dbo].[sc]
WHERE [cno]='1' AND [sno] IN
(SELECT [sno]
FROM[dbo].[sc]
WHERE [cno]!='3'
)
SELECT [sno]
FROM [dbo].[sc]
WHERE [cno]='1' AND [sno] IN
(SELECT [sno]
FROM[dbo].[sc]
WHERE [cno]!='3'
)