分组统计总分数统计每个用户总分select admin_id,sum(score)as score from tb group by admin_id[解决办法
分组统计总分数
统计每个用户总分 select admin_id,sum(score)as score from tb group by admin_id
[解决办法]
select admin_id,sum(score)[score] from tb group by admin_id
[解决办法]
select admin_id,sum(score) from table group by admin_id