文件名称:courses
-
所属分类:
- 标签属性:
- 上传时间:2012-11-16
-
文件大小:1.56kb
-
已下载: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
本网站为编程资源及源代码搜集、介绍的搜索网站,版权归原作者所有! 粤ICP备11031372号
1999-2046 搜珍网 All Rights Reserved.