从student表删除年龄大于30的记录的正确SQL命令是______。
A: DELETE FOR年龄>30
B: DELETE FROM student WHERE年龄>30
C: DELETE student FOR年龄>30
D: DELETE student WHILE年龄>30
A: DELETE FOR年龄>30
B: DELETE FROM student WHERE年龄>30
C: DELETE student FOR年龄>30
D: DELETE student WHILE年龄>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: DEL ETE student FOP年龄>30 D: DELETE student WF IERE年龄>30
- 学生表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
- 从student表删除年龄大于30的记录的正确SQL命令是()。 A: DELETEFOR年龄>30 B: DELETEFROMstudentWHERE年龄>30 C: DELETEstudentFOR年龄>30 D: DELETEstudentWHERE年龄>30