SELECT YEAR(create_time) AS Year, SUM(difference_value) AS TotalVolume FROM energy_consumption_info WHERE YEAR(create_time)='2024' GROUP BY YEAR ORDER BY Year;
SELECT YEAR(create_time) AS Year, MONTH(create_time) AS Month, SUM(difference_value) AS TotalVolume FROM energy_consumption_info WHERE YEAR(create_time)='2024' GROUP BY YEAR(create_time), MONTH(create_time) ORDER BY Year, Month;
SELECT create_time, SUM(difference_value) AS TotalVolume FROM energy_consumption_info GROUP BY create_time ORDER BY create_time;
sql 按年月日统计某个字段和
最新推荐文章于 2024-06-15 12:40:49 发布