单选题
使用SQL语句将学生表S中年龄(AGE)大于30岁的记录删除，正确的命令是( )。
A) DELETE FOR AGE＞30 B) DELETE FROM S WHERE AGE＞30
C) DELETE S FOR AGE＞30 D) DELETE S WHERE AGE＞30
A
B
C
D
【正确答案】
B
【答案解析】
[解析] SQL从表中删除数据的命令格式如下：
DELETE FROM 表名[WHERE 条件]
提交答案
关闭