用 SQL 语句至少教两门课的教师信息的查询
select * from teacher
where teacher.teacher_ID in
(
select course_teacher
from course
group by course.course_teacher
having count(course.course_teacher)>2
);
至少选修了两门课的学生信息的查询
select * from student
where student.stu_ID in
(
select stu_ID
from stu_course
group by stu_course.stu_ID
having count(stu_course.stu_ID)>1
);
某个学生信息的查询、某个教师信息的查询、某门课程信息的查询
--select * from student where stu_name='于兴隆';
--select * from teacher where teacher_name='胡朝举';
--select * from course where course_ID=100001;
某个学生不及格的课程信息的查询。
--select * from course
--where course.course_ID in
--(
--select course_ID
--from stu_course
--where stu_course.stu_ID=10
--and stu_course.stu_mark<60
--);
create or replace procedure stunopas_course
(stu_id in number(2)) is
begin
select * from course
评论0