有三个表，学生表 Stu(Sno,Sname,Ssex,Sbirthday,Sdept)，字段分别表示学号，姓名，性别，出生日期，所在系，学号为主码；课程表Course(Cno,Cname)字段分别表示课程号，课程名，课程号为主码,成绩表SC(Sno, Cno,degree)，字段分别表示学号，课程号，成绩，(Sno,Cno)共同为主码，分别参考Stu,Course表的主码。查询课程号是”C01””C02””CO3”的课程名的语句是？
A: SELECT Cname FROM Course WHERE Cno =”C01”&&”CO2”&&”CO3”
B: SELECT Cname FROM Course WHERE Cno IN ”C01”&&”CO2”&&”CO3”
C: SELECT Cname FROM Course WHERE Cno IN (”C01”, ”CO2”, ”CO3”)
D: SELECT Cname FROM Course WHERE Cno IN( ”C01” AND ”CO2”AND ”CO3”)
A: SELECT Cname FROM Course WHERE Cno =”C01”&&”CO2”&&”CO3”
B: SELECT Cname FROM Course WHERE Cno IN ”C01”&&”CO2”&&”CO3”
C: SELECT Cname FROM Course WHERE Cno IN (”C01”, ”CO2”, ”CO3”)
D: SELECT Cname FROM Course WHERE Cno IN( ”C01” AND ”CO2”AND ”CO3”)
举一反三
- 基于学生—选课—课程数据库中的三个基本表：学生的信息表：STUDENT(sno, sname, sex, age, dept)主码为sno课程信息表：COURSE(cno,cname, teacher)主码为cno学生选课信息表：SC(sno, cno, grade)主码为(sno, cno) “查询没有学习成绩的学生的学号和课程号”的SQL语句是（）。 A: SELECT sno, cno FROM SC WHERE grade=NULL B: SELECT sno, cno FROM SC WHERE grade IS" C: SELECT sno, cno FROM SC WHERE grade IS NULL D: SELECT sno, cno FROM SC WHERE grade="
- 查询选修了'数据库基础'课程的同学的学号,和这些同学选修的全部课程号和分数.select sno,cno,gradefrom ______________________ A: sc where sno in (select sno from sc join course on sc.cno=course.cno where cname='数据库基础') B: sc join course on sc.cno=course.cno where cname='数据库基础' C: sc where sno in (select sno from course where cname='数据库基础') D: sc where cno in (select cno from course where cname='数据库基础')
- 没有选修c01课程同学的学号 SELECT<br/>sno FROM student WHERE<br/>_______________ A: cno<>'c01' B: cno!='c01' C: sno<br/>not in(SELECT sno FROM sc WHERE cno='c01') D: NOT<br/>EXISTS(SELECT * FROM sc WHERE cno='c01'AND student.sno=sno)
- 现有关系student (sno,sname,sex,age)course(cno,cname,credit）sc(sno,cno,socre)查询选了102号课程的学生的学号，姓名和成绩select student.sno,_____,_____from _____,______where ____________ and 课程号='102'
- 查询编号为'c01'的课程考试成绩在80-89之间的学生的学号,下列（）语句不能实现。 A: select sno ,grade from sc where cno='c01' and grade between 80 and 89 B: select sno ,grade from sc where cno='c01' and grade>=80 and grade<90 C: select sno ,grade from sc where cno='c01' and not (grade90) D: select sno ,grade from sc where cno='c01' and grade in (80-89)