mysql每半小时/两小时分组统计平均值

每两小时 

SELECT
	ROUND(avg( cod ),2) cod,
	ROUND(avg(a.tds),2) tds,
	ROUND(avg(a.turbidity),2) tur,
	hTime 
FROM
	(
	SELECT
		cod,
		tds,
		turbidity,
		DATE_FORMAT( concat( date( create_time ), ' ', floor( HOUR ( create_time ) / 2 ) * 2 ), '%H' ) AS hTime 
	FROM
		dc_water_quality 
	WHERE
		create_time >= '2020-06-26 00:00:00' 
		AND create_time <= '2020-06-26 23:59:59' 
	) a 
GROUP BY
	hTime

每半小时

select avg(aa),addtime from (
select pm25 , DATE_FORMAT( concat(date(addtime),' ',hour(addtime),':',floor( minute(addtime)/30 )*30) ,'%Y-%m-%d %H:%i')  as addtime from bb 
 where addtime >= '2019-9-20 06:00:00' and addtime <= '2019-9-20 12:00:00') a
group by DATE_FORMAT( addtime ,'%Y-%m-%d %H:%i');

 

原文地址：https://blog.csdn.net/zhangweiguangsunjiao/article/details/101204093