分组统计总分数
统计每个用户总分 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
发布时间: 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