从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
B
举一反三
- 从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
内容
- 0
使用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
- 1
使用SOL语句将学生表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 > 3
- 2
删除学生表STUDENT中的年龄(字段名为AGE)小于20岁的记录,应该使用的SQL命令是DELETE FROM STUDENT【1】
- 3
下列关于删除表中记录的SQL语句,正确的是( )。 A: DELETE student,where id=11; B: DELETE FROM student where id=11; C: DELETE INTO student where id=11; D: DELETE student where id=11;
- 4
删除student表中id为1的记录，下列语句正确的是 A: DELETE student WHERE id=1; B: DELETE FROM student WHERE id=1; C: DELETE FROM student WHERE id:=1; D: DELETE student WHERE id:=1;