DELETE
FROM
sc
WHERE
sno IN (
SELECT
sno
FROM
student
WHERE
sdept = 'CS'
)
5. 删除计算机科学系所有学生的选课记录。
最新推荐文章于 2022-11-06 09:14:19 发布
DELETE
FROM
sc
WHERE
sno IN (
SELECT
sno
FROM
student
WHERE
sdept = 'CS'
)