如果有学生表student，ssex代表学生性别，sname代表姓名，则想要得到所有姓张和姓王的女学生信息的SQL语句是（）
A: SELECT *
FROM student
WHERE ssex='女' OR sname ='张%' AND sname ='王%'
B: SELECT *
FROM student
WHERE ssex='女' OR sname like '张%' AND sname like '王%'
C: SELECT *
FROM student
WHERE ssex='女' AND (sname like '张%' OR sname like '王%')
D: SELECT *
FROM student
WHERE (ssex='女' AND sname like '张%') OR sname like '王%'
A: SELECT *
FROM student
WHERE ssex='女' OR sname ='张%' AND sname ='王%'
B: SELECT *
FROM student
WHERE ssex='女' OR sname like '张%' AND sname like '王%'
C: SELECT *
FROM student
WHERE ssex='女' AND (sname like '张%' OR sname like '王%')
D: SELECT *
FROM student
WHERE (ssex='女' AND sname like '张%') OR sname like '王%'
举一反三
- 【单选题】若要“检索名字为张某某的所有同学姓名”,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 ‘张_ _’
- 在student（sno，sname，ssex，sage，sdept）表中，查询学生姓名中包含“大”或“小”的学生信息。以下查询语句正确的是（ ）。 A: select * from student where sname in( '_[大小]%') B: select * from student where sname ='%大%' or sname='%小%' C: select * from student where sname like'%大%' or sname like'%小%' D: select * from student where sname 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='张%'
- 查询姓“李”的学生的所有信息 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 ‘%李%
- 从Student表检索姓周的学生，对应的SQL语句是( )。 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 '周_'