文件名称:courses
- 所属分类:
- SQL Server数据库
- 资源属性:
- [SQL] [源码]
- 上传时间:
- 2012-11-26
- 文件大小:
- 2kb
- 下载次数:
- 0次
- 提 供 者:
- 段*
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
/*(2)连接查询实验
1) 在学生选课库中实现其数据连接查询操作。
① 查询每个学生的情况以及他(她)所选修的课程
② 求学生的学号、姓名、选修的课程及成绩
③ 求选修课程10001且成绩在90分以上的学生学号、姓名及成绩
④ 查询每一门课的间接先行课(即先行课的先行课)
-/* (2) join query in Experiment 1) in the student enrollment database query operation to achieve its data connection. ① check each student' s situation and his (her) students seeking elective courses ② school number, name, elective courses and the results ③ seeking elective courses 10001 and results in more than 90 students in student number, name and achievements ④ check first lesson of each class of indirect (ie first course first course)
1) 在学生选课库中实现其数据连接查询操作。
① 查询每个学生的情况以及他(她)所选修的课程
② 求学生的学号、姓名、选修的课程及成绩
③ 求选修课程10001且成绩在90分以上的学生学号、姓名及成绩
④ 查询每一门课的间接先行课(即先行课的先行课)
-/* (2) join query in Experiment 1) in the student enrollment database query operation to achieve its data connection. ① check each student' s situation and his (her) students seeking elective courses ② school number, name, elective courses and the results ③ seeking elective courses 10001 and results in more than 90 students in student number, name and achievements ④ check first lesson of each class of indirect (ie first course first course)
(系统自动生成,下载前可以参看下载内容)
下载文件列表
选课程连接查询.sql