一、背景
二、实现
select * from ( select sum(value) as val from history_data
where parameter_id = '512432211656617105'
or parameter_id = '512432211656637048'
and time >= '2023-12-01 00:00:00' and time<= '2023-12-01 23:59:59' group by parameter_id
)
三、遇到的报错
四、参考博客
- influxDb group sum byinfluxdb group sum by greatest-sum-divisible-by-three only_full_group_by mysql group by greatest-sum-divisible-by-three divisible greatest only-full_group_by only_full_group_by incompatible sql_mode group only_full_group_by mysql group only clause group only_full_group_by nonaggregated group linq by into