select a.username,isnull(a.scoretype,b.scoretype)as scoretype,isnull(A.totalscore,0) from
(select username,scoretype,sum(myscore)as totalscore from table group by username,scoretype) A
full outer join
(select scoretype from table group by scoretype) B
on a.scoretype=b.scoretype
(select username,scoretype,sum(myscore)as totalscore from table group by username,scoretype) A
full outer join
(select scoretype from table group by scoretype) B
on a.scoretype=b.scoretype
2.要求只扫描一遍数据表。
我记得“按钮工厂”先生曾给我用过case语句帮我回答过类似问题。我很满意!
select username,scoretype,sum(myscore)as totalscore from test2 group by username,scoretype
order by username