在线题库
[单选] 删除计算机系学生(在student表中)的修课记录(在SC表中)的语句,正确的是( )。
发布时间:2022-09-12
0次
a. DELETE FROM SC JOIN Student b ON S.Sno = b.Sno
WHERE Sdept = '计算机系'
b. DELETE FROM SC FROM SC JOIN Student b ON SC.Sno = b.Sno
WHERE Sdept = '计算机系'
c. DELETE FROM Student WHERE Sdept = '计算机系'
d. DELETE FROM SC WHERE Sdept = '计算机系'