成人高等教育 / 数据库基础与应用
正确率:100%
下列删除计算机系学生(在student表中)的修课记录(在SC表中)的语句,正确的是( )。
- A、 DELETEFROM 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 StudentWHERE Sdept = '计算机系'
- D、 DELETE FROM SC WHERE Sdept = '计算机系'
参考答案:
佳题速递: