假设表s中有10条记录，其中字段b小于20的记录有3条，大于等于20、并且小于等于30的记录有3条，大于30的记录有4条。执行下面的程序后，屏幕显示的结果是 SET DELETE ON DELETE FROM s WHERE b BETWEEN 20 AND 30 RECCOUNT()
A: 10
B: 7
C: 0
D: 3
A: 10
B: 7
C: 0
D: 3
举一反三
- 已知关系表 S 中有 30 条记录，执行 SQL 语句：DELETE FROM S 后，结果为_____（2016）
- 使用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
- 使用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
- 下面SQL语句中，用于删除student表中age小于20的记录的语句是 A: DELETE student where age<20; B: DELETE FROM student where age<20; C: DELETE FROM student set age<20; D: DELETE studentset age<20;
- 有SQL语句“delete from s where 年龄 > 60“的功能是什么？（ ） A: 从s表中删除年龄大于60岁的记录 B: 从s表中删除年龄大于60岁的首条记录 C: 删除s表 D: 删除s表的年龄列