查询名字中有“金”字的同学的情况,应使用语句
A: SELECT * FROM stu WHERE stuname='_金_'
B: SELECT * FROM stu WHERE stuname='%金%'
C: SELECT * FROM stu WHERE stuname like '_金_'
D: SELECT * FROM stu WHERE stuname like '%金%'
A: SELECT * FROM stu WHERE stuname='_金_'
B: SELECT * FROM stu WHERE stuname='%金%'
C: SELECT * FROM stu WHERE stuname like '_金_'
D: SELECT * FROM stu WHERE stuname like '%金%'
举一反三
- 下面选项中,查询stu表中id值不在2和5之间的学生的SQL语句是( )。 A: select * from stu where id != 2,3,4,5; B: select * from stu where id not betwen 5 and 2; C: select * from stu where id not betwen 2 and 5; D: select * from stu where id not in 2,3,4,5;
- 语句 SELECT * FROM StInfo WHERE ClName = (SELECT ClName FROM StInfo WHERE StName='金萍') 是查询和金萍同班的同学的信息
- 下列语句（）能够查询所有英语类课程的信息。 A: SELECT * FROM Course WHERE cname LIKE ‘%英语’ B: SELECT * FROM Course WHERE cname LIKE ‘%英语%’ C: SELECT * FROM Course WHERE cname LIKE ‘_英语_’ D: SELECT * FROM Course WHERE cname LIKE ‘*英语*’
- 查询姓“李”的学生的所有信息 A: select * from student where sname like ‘#李%’ B: select * from student where sname like ‘%李#’ C: select * from student where sname like “%李%” D: select * from student where sname like ‘%李%
- 要找出所有名字第二个字母为“a”的导演的电影信息，SQL语句为 A: SELECT * FROM Movie WHERE director LIKE ‘_a_’; B: SELECT * FROM Movie WHERE director LIKE ‘%a%’; C: SELECT * FROM Movie WHERE director LIKE ‘%a_’; D: SELECT * FROM Movie WHERE director LIKE ‘_a%’;