单项选择题
删除表Teacher中编号为070041的记录,应为()
A:DELETE FROM Teacher WHERE编号="070041"
B:DELETE FROM Teacher 编号="070041"
C:DELETE编号="070041"FROMTeacher
D:DELETE FROM Teacher WHERE编号IS"070041"
点击查看答案&解析
相关考题
-
单项选择题
根据关系模型Teacher(编号,职称)下列SQL语句正确的是()
A:INSERT INTO Teacher(编号,职称)VALUES("070041","助教")
B:INSERT INTO Teacher("070041","助教")VALUES(编号,职称)
C:INSERT INTO VALUES(编号,职称)Teacher("070041","助教")
D:INSERT INTO VALUES("070041","助教")Teacher(编号,职称 -
单项选择题
在工资数据库表中,若给职工涨工资,最方便的方法是使用以下()方法。
A:追加
B:更新
C:删除
D:生成表查询 -
单项选择题
假设某数据表中有一个"生日"字段,删除80年出生的学生记录的语句是()
A:DELETE FROM Student WHERE生日Between #80-01-01#And#80-12-31#
B:DELETE FROM Student WHERE生日Between("80-01-01"And"80-12-31")
C:DELETE FROM Student WHERE生日Between("80.01.01"And"80.12.31")
D:DELETE FROM Student WHERE生日Between #80.01.01#And#80.12.31#
