查询Student表中“95031”班或性别为“女”的同学记录。
A: select * from student when Class=‘95031’ or Ssex=‘女’
B: select * from student where Class=‘95031’ or Ssex=‘女’
C: select * from student where set Class=‘95031’ or Ssex=‘女’
D: select * from student where Class=‘95031’ and Ssex=‘女’
A: select * from student when Class=‘95031’ or Ssex=‘女’
B: select * from student where Class=‘95031’ or Ssex=‘女’
C: select * from student where set Class=‘95031’ or Ssex=‘女’
D: select * from student where Class=‘95031’ and Ssex=‘女’
举一反三
- 要在student（sno，sname，ssex，sage，sdept）表中，查询全体女生的姓名、年龄，以下正确的查询语句是（ ）。 A: select * from student where ssex='女' B: select 姓名, 年龄 from student where 性别 ='女' C: select sname , sage from student where ssex='女’ D: select sname 姓名, sage 年龄 from student where ssex='女'
- 查询Student表中的所有记录的Sname、Ssex和Class列。 A: select Sname,Ssex,Class from student B: show Sname,Ssex,Class from student C: select * from student D: select Sname,Ssex,Class from course
- 与查询语句select * from student where sage> (select max(sage) from student where ssex='女')等价的是( )。
- 从学生表student查询所有女学生的信息，正确的语句是( )。 A: SELECT B: FROM student where 性别="女"; C: SELECT * FROM student where 性别="女"; D: SELECT ? FROM student where 性别="女"; E: SELECT FROM student where 性别="女";
- 如果有学生表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 '王%'