学生表student中，将年龄小于30岁的记录删除，下面的语句正确的是（ ）。
A: DELETE FROM student FOR age<;30
B: DELETE FROM student WHERE age<;30
C: DELETE TABLE student WHERE age<;30
D: DELETE FROM student HAVING age<;30
A: DELETE FROM student FOR age<;30
B: DELETE FROM student WHERE age<;30
C: DELETE TABLE student WHERE age<;30
D: DELETE FROM student HAVING age<;30
举一反三
- 从student表删除年龄大于=30的记录的正确SQL命令是( )。 A: DELETE FOR年龄>30 B: DELETE FROM student WHERE年龄>30 C: DELETE student FOR年龄>30 D: DELETE student WHERE年龄>30
- 从student表删除年龄大于30的记录的正确SQL命令是 A: A) DELETE FOR 年龄＞30 B: B) DELETE FROM student WHERE 年龄＞30 C: C) DELETE student FOR 年龄＞30 D: D) DELETE student WHERE 年龄＞30
- 从student表删除年龄大于30的记录的正确SQL命令是______。 A: DELETE FOR年龄＞30 B: DELETE FROM student WHERE年龄＞30 C: DELETE student FOR年龄＞30 D: DELETE student WHILE年龄＞30
- 使用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
- 从student表删除年龄大于30的记录的正确SQL命令是 A: DELETE FOR年龄>30 B: DELETE FROM student WHERE年龄>30 C: DEL ETE student FOP年龄>30 D: DELETE student WF IERE年龄＞30