A: SELECT
* FROM student WHERE student_name LIKE('张%'
OR '田%';
B: SELECT
* FROM student WHERE SUBSTRING(student_name,1,1) in('张','田');
C: SELECT
* FROM student WHERE SUBSTRING(student_name,1,1)= '张'
OR SUBSTRING(student_name,1,1)='田';
D: SELECT
* FROM student WHERE student_name LIKE '张%'
OR student_name LIKE '田%';
举一反三
- 检索所有姓“张”、姓“田”的学生信息,可以使用的SQL语句有______。 A: SELECT * FROM student WHERE student_name LIKE( '张%' OR '田%'); B: SELECT * FROM student WHERE SUBSTRING(student_name,1,1) in ('张','田'); C: SELECT * FROM student WHERE SUBSTRING(student_name,1,1)= '张' OR SUBSTRING(student_name,1,1)='田'; D: SELECT * FROM student WHERE student_name LIKE '张%' OR student_name LIKE '田%';
- 检索所有姓“周”，或者姓“陈”的学生信息，可以使用的SQL语句有______。 A: SELECT * FROM studentWHERE student_name LIKE( '陈%' OR '周%'）; B: SELECT * FROM student WHERE SUBSTRING（student_name,1,1) in ('陈','周'）; C: SELECT * FROM student WHERE SUBSTRING（student_name,1,1)= '周' OR SUBSTRING（student_name,1,1)='陈'; D: SELECT * FROM student WHERE student_name LIKE '陈%' OR student_name LIKE '周%';
- 查询姓"张"的学生姓名,下列()语句不能实现。 A: SELECT sname FROM student WHERE left(sname,1)= '张' B: SELECT snameFROM student WHERE sname LIKE '张%' C: SELECT sname FROM student WHERE substring(sname,1,1)= '张' D: SELECT sname FROM student WHERE sname='张%'
- 已知 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 =’王__’;
- 若想查询student表中name为空值的记录，则正确的SQL语句是（ ）。 A: SELECT * FROM student WHERE name = NULL; B: SELECT * FROM student WHERE name like NULL; C: SELECT * FROM student WHERE name = 'NULL'; D: SELECT * FROM student WHERE name is NULL;
内容
- 0
如果有学生表student，ssex代表学生性别，sname代表姓名，则想要得到所有姓张和姓王的女学生信息的SQL语句是（） A: SELECT *<br/>FROM student<br/>WHERE ssex='女' OR sname ='张%' AND sname ='王%' B: SELECT *<br/>FROM student<br/>WHERE ssex='女' OR sname like '张%' AND sname like '王%' C: SELECT *<br/>FROM student<br/>WHERE ssex='女' AND (sname like '张%' OR sname like '王%') D: SELECT *<br/>FROM student<br/>WHERE (ssex='女' AND sname like '张%') OR sname like '王%'
- 1
已知 student 表有姓名字段 name ,并且存在 name 为’sun%er’的记录。下列选项中,以匹配“ sun%er ”字段值的 SQL 语句是 A: SELECT * FROM student WHERE name LIKE ‘sun%er’; B: SELECT * FROM student WHERE name LIKE ‘%%%’; C: SELECT * FROM student WHERE name LIKE '%\%%'; D: SELECT * FROM student WHERE name =‘sun%er’;
- 2
下面查询语句中哪条查询语句会查询出所有包含"李"的数据？ 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‘%李%’
- 3
若想查询student表中name为空值的记录，则正确的SQL语句是（1.0分） A: select * from student where name = null; B: select * from student where name link null; C: select * from student where name = 'null'; D: select * from student where name is null;
- 4
【单选题】若要“检索名字为张某某的所有同学姓名”,SQL语句正确的是()。 A. SELECT Sname FROM Student WHERE Sname Like ‘张____’ B. SELECT Sname FROM Student WHERE Sname Like ‘张%’ C. SELECT Sname FROM Student WHERE Sname Like ‘张_’ D. SELECT Sname FROM Student WHERE Sname Not Like ‘张_ _’