网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
查询student表中的所有非空email信息，以下语句正确的是（）。
- A、Select email from student where email !=null
- B、Select email from student where email not is null
- C、Select email from student where email <> null
- D、Select email from student where email is not null
参考答案
更多 “查询student表中的所有非空email信息，以下语句正确的是（）。A、Select email from student where email !=nullB、Select email from student where email not is nullC、Select email from student where email nullD、Select email from student where email is not null” 相关考题
考题
（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
考题
使用SQL语句从表STUDENT中查询所有姓王的同学的信息，正确的命令是：A）SELECT*FROM STUDENT WHERE LEFT（姓名，2）＝“王”B）SELECT*FROM STUDENT WHERE RIGHT（姓名，2）＝“王”C）SELECT*FROM STUDENT WHERE TRIM（姓名，2）＝“王”D）SELECT*FROM STUDENT WHERE STR(姓名，2)=“王”
考题
对于学生信息表：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
考题
根据SQL标准，下面哪句语句能够找出年龄最小的同学?其中age为学生表student中的年龄字段，sno为学生的学号。()A select max(age) from studentB select sno from student where age = max(age)C select sno from student having age = max(age)D select sno from student a where a.age
考题
根据SQL标准，下面哪条语句与select min(age) from student等效?()A select age from student where age >= min(age)B select distinct age from student where age >= all min(age)C select distinct a.age from student a where a.ageD select distinct a.age from student a where a.age
考题
根据SQL标准，要查询表student中所有年龄age小于所有学生的平均年龄的记录，下面哪条语句适用?()A select * from student where ageB select * from student having ageC select * from student a where a.ageD select * from student a where (select avg(b.age) from student b ) >= a.age
考题
查找学生姓名及其所选修课程的课程号和成绩,正确的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
考题
对于数据表：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语句从表STUDENT中查询所有姓王的同学的信息，正确的命令是：______。A．SELECT*FROM STUDENT WHERE LEFT(姓名，2)=“王”B．SELECT*FROM STUDENT WHERE RIGHT(姓名，2)=“王”C．SELECT*FROM STUDENT WHERE TRIM(姓名，2)=“王”D．SELECT*FROM STUDENT WHERE STR(姓名，2)=“王”
考题
对于学生信息表：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，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
考题
已知有关系“STUDENT”，则关系运算σANE＜80(STUDENT)用SQL语句表示为(52)。A．SELECT( * )FROM STUDENT WHERE AVE ＜ 80B．SELECT( * )FROM STUDENT HAVING AVE ＜ 80C．SELECT(AVE)FROM STUDENT WHERE AVE ＜ 80D．SELECT(AVE） FROM STUDENT HAVING AVE ＜ 80
考题
要找出籍贯是湖北或湖南的学生的姓名和性别，下述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”数据表中的所有记录和字段，则SQL语句为（）A、Selec t姓名，性别 From StudentB、Select*From StudentC、Select 姓名，性别 From Student Where 姓名=“张山“D、Select*From Student Where 姓名=“张山“
考题
数据库中有一张表名称为Student，有列Number，Name，Age，IDCard，Sex。主键为Number。要求查询所有男同学信息，下列哪个SQL语句是正确的？（）A、Select* From Student Where Sex=’男’B、Select* From Student Where Number NotIn（Select Number From Student Where Sex=’男’）C、Select* From Student Where NumberIn（Select Numbe rFrom Student Where Sex=’男’）D、Select* From Student Where Sex’男’
考题
数据库中有一张表名称为Student，有列Name，Age，IDCard，Sex。要求写SQL语句查询出表中年龄介于20和30岁之间的数据，下列哪个SQL语句是正确的？（）A、Select* From Student Where Age=20 ANDAge=30B、Select* From Student Where Age=20 ANDAge=30C、Select* From Student Where Age BET WENN 20AND30D、Select* From Student Where Age=20Age=30"
考题
数据库中有一张表名称为Student，列ZZMM表示学生政治面貌，学生的政治面貌可能为“党员”、“团员”和群众，要求查询政治面貌为“党员”和“团圆的学生信息”，下列哪个SQL语句是正确的（）A、Select* From Student Where ZZMM=’党员’And ZZMM=’团员’B、Select* From Student Where ZZMM=’党员’Or ZZMM=’团员’C、Select* From Student Where ZZMM="党员"OrZ ZMM="团员"D、Select* From Student Where ZZMM IN（’党员’，‘团员’）
考题
查找student表中所有电话号码（列名：telephone）的第一位为8或6，第三位为0的电话号码（）。A、SELECT telephone FROM student WHERE telephoneLIKE’[8，6]%0*’B、SELECT telephone FROM student WHERE telephoneLIKE’（8，6）*0%’C、SELECT telephone FROM student WHERE telephoneLIKE’[8，6]_0%’D、SELECT telephone FROM student WHERE telephoneLIKE’[8，6]_0*’
考题
查询student表中的所有非空email信息，以下语句正确的是（）A、Select email from student where email!=nullB、Select email from student where emailnotisnullC、Select email from student where emailnullD、Select email from student where emailisnotnull
考题
在Transact-SQL语法中，以下SELECT语句正确的是（）。A、SELECT * FROM studentB、SELECT * FROM student WHERE GETDATE（）C、SELECT * FROM student ORDER st_idD、SELECT * FROM student BY St_name
考题
The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds the highest grade point average (GPA) per semester?（）A、SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;B、SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;C、SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;D、SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;E、SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;
考题
The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds the highest grade point average (GPA) per semester?（）A、SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL;B、SELECT (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;C、SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL GROUP BY semester_end;D、SELECT MAX (gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student _ grades;E、SELECT MAX (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;
考题
查询名字中第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‘阳_%’；
考题
单选题查询student表中的所有非空email信息，以下语句正确的是（）A
Select email from student where email!=nullB
Select email from student where emailnotisnullC
Select email from student where emailnullD
Select email from student where emailisnotnull
考题
单选题查询student表中的所有非空email信息，以下语句正确的是（）。A
Select email from student where email !=nullB
Select email from student where email not is nullC
Select email from student where email nullD
Select email from student where email is not null
考题
单选题查询student表中的所有非空email信息，以下语句正确的是（）。A
Select email from student where email !=nullB
Select email from student where email not is nullC
Select email from student where emailnullD
Select email from student where email is no tnull
考题
多选题数据库中有一张表名称为Student，有列Number，Name，Age，IDCard，Sex。主键为Number。要求查询所有男同学信息，下列哪个SQL语句是正确的？（）ASelect* From Student Where Sex=’男’BSelect* From Student Where Number NotIn（Select Number From Student Where Sex=’男’）CSelect* From Student Where NumberIn（Select Numbe rFrom Student Where Sex=’男’）DSelect* From Student Where Sex’男’
热门标签
最新试卷