SELECT
sname
FROM
student
WHERE
EXISTS (
SELECT
*
FROM
sc
WHERE
sc.sno = student.sno
AND sc.cno = 1
)
2. 查询所有选修了1号课程的学生姓名
最新推荐文章于 2022-10-26 16:34:48 发布
SELECT
sname
FROM
student
WHERE
EXISTS (
SELECT
*
FROM
sc
WHERE
sc.sno = student.sno
AND sc.cno = 1
)