从订单表中删除客户号为“1001“的订单记录，正确的SQL语句是()。
A: DROP FROM 订单 WHERE 客户号='1001'
B: DROP FROM 订单 FOR 客户号='1001'
C: DELETE FROM 订单 WHERE 客户号='1001'
D: DELETE FROM 订单FOR 客户号='1001'
A: DROP FROM 订单 WHERE 客户号='1001'
B: DROP FROM 订单 FOR 客户号='1001'
C: DELETE FROM 订单 WHERE 客户号='1001'
D: DELETE FROM 订单FOR 客户号='1001'
举一反三
- 从学生表中删除学号为“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 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”的员工记录，则删除语句应该是（） A: delete from 员工 where 工号=1001 B: delete * from员工where工号=1001 C: delete员工where工号 is 1001 D: delete * from员工where工号 is 1001
- 有订单表如下： 订单(订单号(C,4),客户号(C,4),职员号(C,3),签订日期(D),金额(N,6,2)) 查询每个客户的总金额信息的正确SQL语句是______。 A: SELECT 订单号,SUM(金额) FROM 订单 GROUP BY 客户号 B: SELECT 订单号,SUM(金额) FROM 订单 ORDER BY 客户号 C: SELECT 客户号,SUM(金额) FROM 订单 GROUP BY 客户号 D: SELECT 客户号,SUM(金额) FROM 订单 ORDER BY 客户号