网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
SELECT * FROM Student WHERE Sname LIKE ’张_’语句中的’张_’ 用于查找姓张的学生。
A对
B错
参考答案
参考解析
略
更多 “SELECT * FROM Student WHERE Sname LIKE ’张_’语句中的’张_’ 用于查找姓张的学生。A对B错” 相关考题
考题
（40）查找学生姓名及其所选修课程号和成绩，正确的 SQL 语句是A）SELECT sname FROM student, SELECT cno,grade FROM sc WHERE student.sno =sc.snoB） FROM sname,cno,grade FROM student,course WHERE student.sno =course.cnoC） SELECT sname ,canme,grade FROM student,course,sc WHERE student.sno =sc.sno and sc.cno=course.cnoD） SELECT sname ,cno,grade FROM student,sc WHERE student.sno =sc.sno
考题
（41）若要求查找姓名中第二个字为‘阳’字的学生的学号和姓名，下列 SQL 语句中，哪一个（些）是正确的？Ⅰ．SELECT S#，SNAME FROM S WHERE SNAME = '__阳%'Ⅱ. SELECT S#，SNAME FROM S WHERE SNAME LIKE '__阳%'Ⅲ. SELECT S#，SNAME FROM S WHERE SNAME LIKE '%阳%'A）只有ⅠB）只有ⅡC）只有ⅢD）都正确
考题
若要求查找‘李’姓学生的学生号和姓名，正确的SQL语句是A．SELECT S#,SNAME FROM S WHERE SNAME='李%.'B．SELECT S#,SNAME FROM S WHERE SNAME LIKE '李%.'C．SELECT S#,SNAME FROM S WHERE SNAME='%.李%.'D．SELECT S#,SNAME FROM S WHERE SNAME LIKE '%.李%.'
考题
“从学生关系S中检索姓′王′的学生学号”的SQL语句是A．SELECT sno FROM sc WHERE sname=′王′B．SELECT sno FROM sc WHERE sname IS LIKE′王%′C．SELECT sno FROM sc WHERE sname LIKE′王%′D．SELECT sno FROM sc WHERE sname LIKE′王_′
考题
对于学生信息表：student(sno，sname，sex，age，dept)，能够得到年龄在20岁到22岁之间的学生的姓名和学号的语句是A．SELECT * FROM student WHERE age BETWEEN 20 AND 22B．SELECT sname，sno FROM student WHERE age BETWEEN 20 AND 22C．SELECT sname，sno FROM student WHERE age＞=20D．SELECT sname，sno FROM student WHERE age＜=22
考题
以下2题基于以下说明。设有三个关系：学生关系S(SNO，SNAME，AGE，SEX) (分别代表学生的学号、姓名、年龄、性别)学习关系SC(SNO，CNO，GRADE) (分别代表学生的学号、课程编号、成绩)若在关系S中查找姓名中第一个字为′王′的学生的学号和姓名。下面列出的SQL语句中，正确的是A．SELECT SNO,SNAME FROM S WHERE SNAME=′王%′B．SELECT SNO,SNAME FROM S WHERE SNAME=′王_′C．SELECT SNO,SNAME FROM S WHERE SNAME LIKE′王%′D．SELECT SNO,SNAME FROM S WHERE SNAME LIKE′王_′
考题
若要求查找姓名中第一个字为“李”的学生号和姓名。下面列出的SQL语句中，哪个(些)是正确的?Ⅰ．SELECT S#，SNAME FROM S WHERE SNAME=‘李％’Ⅱ．SELECT S#，SNAME FROM S WIERE SNAME LIKE'李％'Ⅲ．SELECT S#，SNAME FROM S WHERE SNAME LIKE'李_'A．ⅠB．ⅡC．ⅢD．全部
考题
在学生表STUD中查询所有姓张的学生的信息，使用的SQL语句是______。A．SELECT * FROM STUD WHERE 姓名LIKE“张％”B．SELECT * FROM STUD WHERE 姓名IN(“张％”)C．SELECT * FROM STUD WHERE 姓名LIKE“张$”D．SELECT * FROM STUD WHERE 姓名IN(“张$)”
考题
查找学生姓名及其所选修课程的课程号和成绩,正确的SQL语句是A．SELECT sname FROM student,SELECT cno,grade FROM sc WHERE student.sno=sc.snoB．SELECT sname,cno,grade FROM student,course WHERE student.sno=course.cnoC．SELECT sname,cname,grade FROM student,course,sc WHERE student.sno=sc.sno and sc.cno=course,cnoD．SELECT sname,cno,grade FROM student,sc WHERE student.sno=sc.sno
考题
若要求查找姓名中第一个字为“刘”的学生号和姓名。下面列出的SQL语句中，正确的是( )。A．SELECT S#，SNAME FROM S WHERE SNAME='刘%.'B．SELECT S#，SNAME FROM S WHERE SNAME='刘_'C．SELECT S#，SNAME FROM S WHERE SNAME LIKE'刘%.'D．SELECT S#，SNAME FROM S WHERE SNAME LIKE'刘_'
考题
若要求查找姓名中第一个字为’王’的学生号和姓名。下面列出的SQL语句中，哪个(些)是正确的?______。 Ⅰ．SELECT S#,SNAME FROM S WHERE SNAME='王%' Ⅱ．SELECT S#,SNAME FROM S WHERE SNAME LIKE'王%' Ⅲ．SELECT S#,SNAME FROM S WHERE SNAME LIKE'王_'A．ⅠB．ⅡC．ⅢD．全部
考题
对于数据表：student(sno,sname,sex,age,grade)，查询学习成绩为空的学生的学号和姓名，下面语句正确的是______。A．SELECT sno,sname FROM student WHERE gade=NULLB．SELECT sno,sname FROM student WHERE grade IS NULLC．SELECT sno,age FROM student WHERE grade IS NULLD．SELECT mo,age FROM student WHERE grade=NULL
考题
若要求查找姓名中第一个字为，王，的学号和姓名。下面列出的SQL语句中，哪个(些)是正确的? ( ) Ⅰ．SELECT S#，SNAME FROM S WHERE SNAME='王%' Ⅱ．SELECT S#，SNAME FROM S WHERE SNAME LIKE='王%' Ⅲ．SELECT S#，SNAME FROM S WHERE SNAME LIKE='王%'A．ⅠB．ⅡC．ⅢD．全都是
考题
对于学生信息表：student(sno，sname，sex，age，dept)，要查询所有刘姓学生的信息，正确的语句是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(sno, sname, sex, age, dept)，能够得到年龄在20岁于22岁之间的学生的姓名和学号的语句是A．SELECT * FROM student WHERE age BETWEEN 20 AND 22B．SELECT sname, sno FROM student WHERE age BETWEEN 20 AND 22C．SELECT sname,sno FROM student WHERE age＞＝20D．SELECT shame,sno FROM student WHERE age＜＝22
考题
对于学生信息表：student(sno，sname，sex，age，grade)，查询学习成绩为空的学生的学号和姓名，下面语句正确的是A．SELECT sno，sname FROM student WHERE grade=NULLB．SELECT sno，sname FROM student WHERE grade IS NULLC．SELECT sno，age FROM student WHERE grade IS NULLD．SELECT sno，age FROM student WHERE grade=NULL
考题
若要求查找姓名中第一个字为，王，的学生号和姓名。下面列出的SQL语句中( )是正确的。Ⅰ．SELECT S#，SNAME FROM S WHERE SNAME='王%'Ⅱ．SELECT S#，SNAME FROM S WHERE SNAME='王%'Ⅲ．SELECT S#，SNAME FROM S WHERE SNAME LIKE'王_'A．ⅠB．ⅡC．ⅢD．全部
考题
若要求查找姓名中第一个字为'王'的学生号和姓名。下面列出的SQL语句中，哪个（些）是正确的？ Ⅰ.SELECT S#，SNAME FROM S WHERESNAME=′王%′ Ⅱ.SELECT S#，SNAME FROM S WHERE SNAME LIKE′王%′ Ⅲ.SELECT S#，SNAME FROM S WHERE SNAME LIKE′王_′A．ⅠB．ⅡC．ⅢD．全部
考题
要找出籍贯是湖北或湖南的学生的姓名和性别，下述SQL语句正确的有哪三项（）。A、SELECT Sname，Ssex FROM Student WHERE Sdept=（‘湖南’，‘湖北’）；B、SELECT Sanme，Ssex FROM Student WHERE Sdept=’湖南’ORSdept=’湖北’；C、SELECT Sname，Ssex FROM Student WHERE Sdep tLIKE‘湖%’D、SELECT Sname，Ssex FROM Student WHERE Sdept LIKE‘%湖’；E、SELECT Sname，Ssex FROM Student WHERE Sdept IN（‘湖南’，‘湖北’）；
考题
设student表中存放了学生的信息，要从student表中查出姓名（sname）的第二个字是“光”或"明"的学生的信息，正确的查询语句为： select * from student where（）A、sname LIKE ’_[^光明]%’B、.sname LIKE ’_^光明%’C、sname LIKE ’_光明%’D、sname LIKE ’_[光明]%’
考题
查询名字中第2个字为“阳”的学生的姓名和学号，正确的是（）A、Select Sname，Sno from student where Sname like‘_阳%’；B、Select Sname，Sno from student where Sname like‘阳%’；C、Select Sname，Sno from student where Sname like‘_阳’；D、Select Sname，Sno from student where Sname like‘阳_%’；
考题
单选题查询名字中第2个字为“阳”的学生的姓名和学号，正确的是（）A
Select Sname，Sno from student where Sname like‘_阳%’；B
Select Sname，Sno from student where Sname like‘阳%’；C
Select Sname，Sno from student where Sname like‘_阳’；D
Select Sname，Sno from student where Sname like‘阳_%’；
考题
判断题SELECT * FROM Student WHERE Sname LIKE ’[张李刘]%’ 语句可以查找姓张、李、刘的学生。A
对B
错
热门标签
最新试卷
