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
不能在数据集中写代码吗 作者: yhdata_lyaa 时间: 昨天 17:53
菜鸟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;
