mysql根据用户id分组读取两列的总和倒叙排列后取前十条sql语句

select uid,sum(totalcoin+total_livecoin) as totalcoin from cmf_users_coinrecord where type='expend' group by uid order by totalcoin desc limit 0,10

没有更多推荐了,返回首页