现有以下数据 :
CREATE TABLE aa
(
id
varchar(10) DEFAULT NULL,
user_id
varchar(10) DEFAULT NULL,
money
int(10) DEFAULT NULL,
sum_money
int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
目标数据 :
根据user_id 进行分组 ,根据id进行排序 ,
- id = 1 id_1_sum_money = id1_money id_1_sum_money = 10
- id = 2 id_1_money + id_2_money = id_2_sum_money 10+10 = 20
- id = 3 id_2_money + id_3_money = id_3_sum_money 20+30 = 50
实现方法 :
SELECT a.id,a.user_id,a.money
,(
SELECT SUM(b.money)
FROM aa b
WHERE a.user_id = b.user_id
AND a.id >= b.id
)sum_money
FROM aa a