select [学生], sum( [奖] ) as [总奖金] from 表 group by [学生]可是该学生的课目不是唯一的呀..你这样统计是错的.
Select 学生,课目,min(奖) as 奖 from tbl group by 学生,课目
select [学生], str(sum(cast(rtrim(stuff([奖],len([奖]),1,'')) as decimal(5,2))),5,1)+'$' as [总奖金] from 表 group by [学生]
Select 学生,课目,max(奖) as 奖 from 表 group by 学生,课目
select b.学生, str(sum(cast(rtrim(stuff(b.奖,len(b.奖),1,'')) as decimal(5,2))),5,1)+'$' as 总奖金 from (Select 学生,min(奖) as 奖,课目 from 表 group by 学生,课目) as b group by b.学生
from 表
group by [学生]可是该学生的课目不是唯一的呀..你这样统计是错的.
from tbl
group by 学生,课目
from 表
group by [学生]
from (Select 学生,min(奖) as 奖,课目 from 表 group by 学生,课目) as b
group by b.学生