A: select * from student where sno= '05880101' and sno= '05880102'
B: select * from student where sno= '05880101' or sno= '05880102'
C: select * from student where sno= '05880101'
D: select * from student where sno= '05880102'
举一反三
- select * from student where sno=’05880101’ union select * from student where sno=’05880102’ 与此查询语句等价的选项是（ ）。
- 在学生选课数据库中，查询选修了课程的学生的学号、姓名，SQL语句可为（ ） A: SELECT DISTINCT Sno, Sname FROM Student, SC WHERE Student.Sno = SC.Sno; B: SELECT Sno, Sname FROM Student, SC WHERE Student.Sno = SC.Sno; C: SELECT DISTINCT Sno, DISTINCT Sname FROM Student WHERE Student.Sno IN (SELECT Sno FROM SC); D: SELECT Sno, Sname FROM Student WHERE Student.Sno IN (SELECT DISTINCT Sno FROM SC);
- 查找学生表student中姓名的第二个字为“t”的学生学号sno和姓名sname，下面SQL语句正确的是（）。 A: SELECT sno, sname FROM student WHERE sname='_t%'; B: SELECT sno, sname FROM student WHERE sname LIKE '_t%'; C: SELECT sno, sname FROM student WHERE sname＝'%t_'; D: SELECT sno, sname FROM student WHERE sname LIKE '%t_';
- 对于学生信息表：student(sno，sname，sex，age，grade)，查询学习成绩为空的学生的学号和姓名，下面语句正确的是 A: SELECT sno，sname FROM student WHERE grade=NULL B: SELECT sno，sname FROM student WHERE grade IS NULL C: SELECT sno，age FROM student WHERE grade IS NULL D: SELECT sno，age FROM student WHERE grade=NULL
- 查询曾经考过100分的学生的学号，可以使用的SQL语句是：（ ） A: SELECT ALL Sno FROM SC WHERE Grade = 100; B: SELECT DISTINCT Sno FROM SC WHERE Grade = 100; C: SELECT ALL Sno FROM Student WHERE SGrade = 100; D: SELECT DISTINCT Sno FROM Student WHERE SGrade = 100;
内容
- 0
下列查询中,属于相关子查询的有（）。 A: SELECT * FROM student WHERE sno IN (SELECT sno FROM sc WHERE cno='1'); B: SELECT sno, cno FROM SC x WEHRE grade>=(SELECT AVG(grade) FROM SC y WHERE y.sno = x.sno); C: SELECT sname FROM student WHERE EXISTS(SELECT * FROM sc WHERE sno=student.sno AND cno='1'); D: SELECT sname FROM student WHERE NOT EXISTS(SELECT * FROM course WHERE NOT EXISTS(SELECT * FROM sc WHERE sc.sno=student.sno AND sc.cno=course.cno));
- 1
如果有学生表student，sno代表学号，sage代表年龄，则想要得到年龄在18到20之间的学生学号的SQL语句是（） A: SELECT sno<br/>FROM student<br/>WHERE sage>18 or sage<20 B: SELECT sno<br/>FROM student<br/>WHERE sage=18 C: SELECT sno<br/>FROM student<br/>WHERE sage in (18,20) D: SELECT sno<br/>FROM student<br/>WHERE sage between18 and 20
- 2
对于学生信息表：student(sno，sname，sex，age，dept)，能够得到年龄在20岁至22岁之间的学生的姓名和学号的语句是( )。 A: SELECT*FROM student WHERE age BETWEEN 20 AND 22 B: SELECT sname，sno FROM student WHERE age BETWEEN 20 AND 22 C: SELECT sname，sno FROM student WHERE age>=20 D: SELECT sname，sno FROM student WHERE age<=22
- 3
查询选修1号课程的学生姓名的sql语句为： select sname from student where sno = (select sno from sc where cno=1);
- 4
以下命令是相关子查询的嵌套查询是： A: SELECT * FROM student WHERE sno IN (SELECT sno FROM sc WHERE cno = '1') B: SELECT * FROM student WHERE EXISTS (SELECT * FROM sc WHERE cno = '1' AND sc.sno = student.sno) C: SELECT sno, cno FROM sc x WHERE grade>(SELECT AVG(grade) FROM sc y WHERE y.sno = x.sno) D: 以上都是