还是问一个mysql的查询汇总的汇总问题
id uid scroe<br /> -------------<br /> 1 1 1.5<br /> 2 1 1.8<br /> 3 2 -5.5<br /> 4 1 0.8<br /> 5 2 8.2<br /> 6 1 -2<br /> 7 4 3<br /> 8 2 2.3<br /> --------------
用户 分数 汇总分<br /> -----------------------<br /> 1 1.5 2.1<br /> 1 1.8 2.1<br /> 1 0.8 2.1<br /> 1 -2 2.1<br /> 2 -5.5 5<br /> 2 8.2 5<br /> 2 2.3 5<br /> 3 0 0<br /> 4 3 3<br /> 5 0 0<br />
select t.*,round(s.scroe,1) as scroe , round(if(s.total is null,0,s.total),1) as summary from <br /> (select 1 as uid <br /> union <br /> select 2 as uid<br /> union<br /> select 3 as uid <br /> union <br /> select 4 as uid<br /> union <br /> select 5 as uid) t left join <br /> (select uid,scroe,(select sum(scroe) from a where uid=aa.uid group by uid) as total from a as aa) s<br /> on s.uid = t.uid
