分组后 求和
2020-02-13 本文已影响0人
xueyueshuai
SELECT
sum(money) as m,
equipment_id
FROM lyb_equipment_profit
WHERE user_id
= 100 GROUP BY equipment_id
SELECT
sum(money) as m,
equipment_id
FROM lyb_equipment_profit
WHERE user_id
= 100 GROUP BY equipment_id