如果你对其他数据库原理的实验感兴趣,请考虑阅读我的专栏
实验三 数据高级查询
实验目的:
掌握复杂数据查询操作。
掌握各种连接查询、嵌套查询的使用
实验过程:
(1)查询每个学生及其选课情况;
SELECT Student.Sname, SC.Cno
FROM Student,SC
WHERE Student.Sno = SC.Sno
(2)查询每门课的间接先修课
SELECT c1.cname, c2.cpno
FROM course c1, course c2
WHERE c1.cpno = c2.cno
(3)将STUDENT,SC进行右连接
SELECT *
FROM student RIGHT JOIN sc
ON Student.Sno = sc.Sno
(4)查询既选修了2号课程又选修了3号课程的学生姓名、学号;
SELECT Sname,Sno
FROM Student
WHERE Student.Sno IN(
SELECT Sno
FROM SC
WHERE CNO = '2'
AND SNO
IN(
SELECT Sno
FROM SC
WHERE Cno