读书人

分组统计总分数解决思路

发布时间: 2013-03-13 10:56:58 作者: rapoo

分组统计总分数
分组统计总分数解决思路
统计每个用户总分 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

读书人网 >SQL Server

热点推荐