BI中怎么实现分组累加求和

分组累计？什么样的。这样可以吗

yhdata_lyaa 发表于 2025-1-10 17:14
分组累计？什么样的。这样可以吗

select data_date,vehicle_model,sum(end_mileage),sum(hydrogen_consumption)over(partition by vehicle_model order by data_date)
from ftxt_bi.yutong_track_info_zpl
group by data_date,vehicle_model
不能在数据集中写代码吗

菜鸟w 发表于 2025-1-10 17:18
select data_date,vehicle_model,sum(end_mileage),sum(hydrogen_consumption)over(partition by vehicle_ ...

分组合计？
SELECT product_id, SUM(amount) AS total_sales
FROM sales
GROUP BY product_id;