使用SQL语句将表S中字段price的值大于30的记录删除,正确的命令是
A.DELETE FROM s FOR price>30
B.DELETE FROM s WHERE price>30
C.DELETE s FOR price>30
D.DELETE s WHERE price>30
第1题:
在SQL语句中,要删除仓库表中仓库号的字段值是WHl的记录,可利用命令:
第2题:
使用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
第3题:
使用SQL语句将表s中字段price的值大于30的记录删除,正确的命令是( )。
A.DELETE FROM S FOR price>30
B.DELETE FROM sWHERE price>30
C.DELETE S FOR pricC>30
D.DELETE S WHERE pricC>30
第4题:
在SQL语句中,要删除仓库表中仓库号的字段值是WH1的记录,可利用命令:
【 】FROM仓库WHERE仓库号="WH1"
第5题:
使用SQL语句将学生表S中年龄(AGE)大于30岁的记录删除,正确的命令()
A、DELETEFORAGE30
B、DELETEFROMSWHEREAGE30
C、DELETESFORAGE30
D、DELETESWHEREAGE30
第6题:
使用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
第7题:
使用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
第8题:
使用SQL语句将学生表S中年龄(AGE)大于30岁的记录删除,正确的命令是A)DELETE FOR AGE>30 B)DELETE FROM S WHERE AGE>30C)DELETE S FOR AGE>30 D)DELETE S WHERE AGE>30
第9题:
使用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