oracle练习2015（含答案）(2)

2019-09-01 13:32

45、查询所有选修“计算机导论”课程的“男”同学的成绩表

SELECT * FROM LIU.SCORE WHERE CNO IN(SELECT CNO FROM LIU.COURSE WHERE CNAME ='计算机导论')

AND SNO IN(SELECT SNO FROM LIU.STUDENT WHERE SSEX ='男')

-46、查询出选修课程号为3-245和6-166的课程的学生学号与姓名

SELECT SNO,SNAME FROM LIU.STUDENT WHERE SNO IN (SELECT SNO FROM LIU.SCORE WHERE CNO='3-245') AND SNO IN

(SELECT SNO FROM LIU.SCORE WHERE CNO='6-166')

--47、查询出没有选修课程号为3-245和6-166的课程的学生学号与姓名

SELECT SNO,SNAME FROM LIU.STUDENT WHERE SNO NOT IN (SELECT SNO FROM LIU.SCORE WHERE CNO='3-245' INTERSECT

SELECT SNO FROM LIU.SCORE WHERE CNO='6-166')

oracle练习2015（含答案）(2).doc 将本文的Word文档下载到电脑下载失败或者文档不完整，请联系客服人员解决！