查询所有的

 查询所有的数据，每个小时取一条数据

SELECT
		id ,
    DATE_FORMAT(
		send_time,
		'%Y-%m-%d %k:00:00'
	  ) send_time,
	`sequence`,
	region_code ,
	CODE,
	address,
	event_type ,
	water_tmp_val ,
	ph_val ,
	diandl_val ,
	rongy_val ,
	zhuodu_val
FROM
	water_data_item
WHERE
	1=1 
	 GROUP BY
	DATE_FORMAT(
		send_TIME,
		'%Y-%m-%d %k:00:00'
	)
ORDER BY
	send_time DESC