oracle ²éѯÓï¾ä

CREATE PROCEDURE SP_ClassGradeQuery 
(TeachingYearId in char(2) ,classid in char(7))
as 
begin
begin
select Tb_Student.stuid ,stuName ,sum(Tb_Course.CourseGrade)as Ó¦»ñ×Üѧ·Ö
from Tb_Grade,Tb_Student ,Tb_Course
where Tb_Student.stuid = Tb_Grade.stuid and Tb_Grade.CourseId=Tb_Course.CourseId and tb_grade.classid =classid and tb_grade.TeachingYearId=TeachingYearId
group by Tb_Student.stuid ,stuName
end
select Tb_Student.stuid ,stuName ,sum(Tb_Course.CourseGrade)as ÒÑѧ·Ö
from Tb_Grade,Tb_Student ,Tb_Course
where Tb_Student.stuid = Tb_Grade.stuid and Tb_Grade.CourseId=Tb_Course.CourseId 
and (CommonScore*0.1+MiddleScore*0.2+LastScore*0.7)>60 and tb_grade.classid =classid and tb_grade.TeachingYearId=TeachingYearId
group by Tb_Student.stuid ,stuName 
end

ÎÒÏë²éѯ³öµÄ½á¹ûÊÇ£ºStuId£¬StuName£¬ÒÑ»ñ×Üѧ·Ö£¬Ó¦»ñ×Üѧ·Ö£¬»ñÈ¡±ÈÀý
ÕâÒªÔõô×öÄØ?ÎÒÖ»»á·Å¿ªÐ´£¬ÇëÄÄλ°ïÎÒһϣ¬ÏÈллÁË

---

SQL code:
CREATE PROCEDURE SP_ClassGradeQuery(i_TeachingYearId IN CHAR(2),
i_classid IN CHAR(7),
o_ref OUT SYS_REFCURSOR) AS
BEGIN
--·µ»ØÓαê
OPEN o_ref FOR
SELECT stuid,
stuName,
CG AS ÒÑ»ñѧ·Ö,
totoalCG AS Ó¦»ñ×Üѧ·Ö,