麻烦大家帮我看个计算字段的sql

fengmnll 发布于 2010-05-22 20:07， 725 次点击

只有本站会员才能查看附件，请登录

麻烦大家,我现在就是要求出具体学生某一学年获得所有的课外活动的成绩,attend(课外活动表)attend_grade是获得的学分,student_attend(学生参加课外活动表)attednd_date是时间,student是学生表,谢谢.

3 回复

aei1352010-05-22 22:05

select c.student_id,c.student_name,m.学年,m.成绩 from student c inner join
(select b.student_id,datepart(year,b.attend_date) 学年,sum(c.attend_grade) as 成绩 from attend a inner join student_attend b
on a.attend_id=b.attend_id group by b.student_id,datepart(year,b.attend_date)) m
on c.student_id=m.student_id

道道追求2010-05-22 22:30

试一下创建一个存储过程
create proc AttendGrade
@Attend_date as nvarchar(50),@Student_name as nvarchar(50)
as
select attend_name as 课外活动名称,attend_grade as 成绩 from attend where attend_id=(select attend_id from student_attend where student_date=@Attend_date and student_id=(select student_id from student where student_name=@Student_name))

我也是初学的，不知道对不对，试试喽
不对别骂我

fengmnll2010-05-24 09:55

回复 3楼道道追求

呵呵,谢谢