还是问一个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
