------解决方案-------------------- 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