从表R中删除所有姓"李"的学生记录，其中NAME表示学生姓名，下列语句中正确的是（）。
A: DELETE FROM R WHRER NAME LIKE'李%'
B: DELETE ALL FROM R WHERE NAME='李'
C: DELETE WHERE NAME='李'
D: REVOKE ALL FROM R WHERE NAME LIKE'李'
A: DELETE FROM R WHRER NAME LIKE'李%'
B: DELETE ALL FROM R WHERE NAME='李'
C: DELETE WHERE NAME='李'
D: REVOKE ALL FROM R WHERE NAME LIKE'李'
举一反三
- 下面查询语句中哪条查询语句会查询出所有包含"李"的数据？ A: select * from student where name limit‘%李%’ B: select * from student where name =‘%李%’ C: select * from student where name like‘%李%’ D: select * from student where name in‘%李%’
- 下面删除记录的语句正确的是( ) A: delete from emp where name="Tony"; B: delete * from emp where name="Tony"; C: drop from emp where name="Tony"; D: drop * from emp where name="Tony";
- 删除所有学生表中所有姓赵的同学信息可以使用_____. A: DELETE FROM 学生表 WHERE 姓名="赵%" B: DELETE FROM 学生表 WHERE 姓名="赵_" C: DELETE FROM 学生表 WHERE 姓名 like "赵%" D: DELETE FROM 学生表 WHERE 姓名 like "赵_"
- 下列语句中查询姓李的学生的语句是( ) A: select * from 表名 where 姓名=‘李’ B: select * from 表名 where 姓名 like ‘李%’ C: select * from 表名 where 姓名 like ‘%李%’ D: select * from 表名 where 姓名 like ‘李’
- 已知 student 表有姓名字段 name。若想查询所有姓“王”的学生,并且姓名由三个字符组成,则应使用的SQL 语句是 A: SELECT* FROM student WHERE name LIKE ‘王__’; B: SELECT* FROM student WHERE name LIKE ‘王%_’; C: SELECT* FROM student WHERE name LIKE ‘王%’; D: SELECT* FROM student WHERE name =’王__’;