查询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
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
举一反三
- 查询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=‘女’
- 要在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，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 '王%'
- 查询Student表中的所有记录的Sname、Ssex和Class列。
- 在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 '%[大小]%'