从学生表中删除学号为“1001”的学生记录，正确的SQL语句是______。 A: DROP FROM Student WHERE 学号="1001" B: DROP FROM Student FOR 学号="1001" C: DELETE FROM Student WHERE 学号="1001" D: DELETE FROM Student FOR 学号="1001"

公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！

2022-06-04

从学生表中删除学号为“1001”的学生记录，正确的SQL语句是______。 A: DROP FROM Student WHERE 学号="1001" B: DROP FROM Student FOR 学号="1001" C: DELETE FROM Student WHERE 学号="1001" D: DELETE FROM Student FOR 学号="1001"

从学生表中删除学号为“1001”的学生记录，正确的SQL语句是______。
A: DROP FROM Student WHERE 学号="1001"
B: DROP FROM Student FOR 学号="1001"
C: DELETE FROM Student WHERE 学号="1001"
D: DELETE FROM Student FOR 学号="1001"

答案：

查看

举一反三

下列各题使用如下表： Student.dbf(学号，姓名，课程号，成绩) 从学生表中删除学号为“1001”的学生记录，正确的SQL语句是______。 A: DROP FROM Student WHERE学号="1001" B: DROP FROM Student FOR学号="1001" C: DELETE FROM Student WHERE学号="1001" D: DELETE FROM Student FOR学号="1001"
从学生表中删除学号为“1001”的学生记录，正确的SQL语句是______。 A: DELETE FROM 学生 WHERE 学号="1001" B: DROP FROM 学生 FOR 学号="1001" C: DROP FROM 学生 WHERE 学号="1001" D: DELETE FROM 学生 FOR 学号="1001"
下列各题使用如下2个表：学生表(学号，姓名，性别，出生日期，课程编号，成绩) 课程表(课程编号，课程名称) 从学生表中删除学号为“1001”的学生记录，正确的SQL语句是______。 A: DELETE FROM学生WHERE学号="1001" B: DROP FROM学生FOR学号="1001" C: DROP FROM学生WHERE学号="1001" D: DELETE FROM学生FOR学号="1001"
从订单表中删除客户号为“1001“的订单记录，正确的SQL语句是()。 A: DROP FROM 订单 WHERE 客户号='1001' B: DROP FROM 订单 FOR 客户号='1001' C: DELETE FROM 订单 WHERE 客户号='1001' D: DELETE FROM 订单FOR 客户号='1001'
设“学生”表中有 “学号”等字段,删除学号为“S01002”的学生的记录,正确的SQL语句是( )。 A: DELETE 学号="S01002" B: DELETE FROM 学号="S01002" C: DELETE 学号="S01002" FROM 学生 D: DELETE FROM 学生 WHERE 学号="S01002"