问题详情

删除计算机系学生(在student表中)的修课记录(在SC表中)的正确的语句是表是(    )


A、DELETE &nbsp;FROM SC JOIN Student b ON S.Sno = b.Sno<br>WHERE Sdept = '计算机系'

B、DELETE FROM SC FROM SC JOIN Student b ON SC.Sno = b.Sno<br>WHERE Sdept = '计算机系'

C、DELETE FROM Student &nbsp;WHERE Sdept = '计算机系'

D、DELETE FROM SC WHERE Sdept = '计算机系'

时间:2021-07-17 18:52 关键词:

答案解析

A