查询所有的数据,每个小时取一条数据
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