题目内容

如果有学生表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 '王%'

查看答案

搜索结果不匹配？点我反馈

更多问题

如果有学生表student，classno代表班级号，sname代表姓名，则想要得到201701班所有姓张的学生信息的SQL语句是（）

A. SELECT * FROM student WHERE classno='201701' AND sname ='张%'
B. SELECT * FROM student WHERE classno='201701' OR sname ='张%'
C. SELECT * FROM student WHERE classno='201701' AND sname like '张%'
D. SELECT * FROM student WHERE classno='201701' OR sname like '张%'

查看答案

如果有学生表student，classno代表班级号，sname代表姓名，则想要得到201701班所有姓张和姓王的学生信息的SQL语句是（）

A. SELECT * FROM student WHERE classno='201701' AND sname ='张%' AND sname ='王%'
B. SELECT * FROM student WHERE classno='201701' AND sname like '张%' AND sname like '王%'
C. SELECT * FROM student WHERE classno='201701' AND sname like '张%' OR sname like '王%'
D. SELECT * FROM student WHERE classno='201701' AND (sname like '张%' OR sname like '王%'）

查看答案

在JSP页面中通过将本页面请求转发至指定URL的文件如target，则在该URL文件/target中可接受数据的作用域范围是（）

A. request
B. page
C. session
D. application

查看答案

如果有学生表student，sno代表学号，sage代表年龄，则想要得到年龄在18到20之间的学生学号的SQL语句是（）

A. SELECT sno FROM student WHERE sage>18 or sage<20
B. SELECT sno FROM student WHERE sage=18
C. SELECT sno FROM student WHERE sage in (18,20)
D. SELECT sno FROM student WHERE sage between18 and 20

查看答案