mysql - sql 不用group by 怎么求和

Question

对uid 相同的记录的money 求和

比如uid 387 的记录 结果
uid 金额 求和的金额
387 2000.00 5000.00
387 3000.00 5000.00

因为我需要记录的明细 所有不能用group by

Answer 1

我知道SQL语法很强大，不过我也不是很精通，针对你的需求，我提供如下参考意见。

select a.uid,a.money,c.total_money from (select b.uid,sum(b.money) as total_money from leshi_deal_invest as b group by b.uid) as c 
right join leshi_deal_invest as a 
on a.uid = c.uid;

Answer 2

select b.uid, b.money, a.total from (select uid, sum(money) as total from test group by uid) as a, test as b where a.uid = b.uid

够懒的