sql查询当天的数据，每个小时只取1条

 查询当天的,按小时分  

DATE_FORMAT() 函数用于以不同的格式显示日期/时间数据。

语法

DATE_FORMAT(date,format)

SELECT 
	id ,
    DATE_FORMAT(
		send_time,
		'%Y-%m-%d %k:00:00'
	  ) ,
	`sequence`,
	region_code ,
	CODE,
	address,
	event_type ,
	water_tmp_val ,
	ph_val ,
	diandl_val ,
	rongy_val ,
	zhuodu_val
from water_data_item WHERE year(send_time)=year(NOW()) AND MONTH(send_time)=MONTH(NOW()) and  DAY(send_time)=DAY(NOW())
 GROUP BY
	DATE_FORMAT(
		send_TIME,
		'%Y-%m-%d %k:00:00'
	)
ORDER BY
	send_time DESC Limit 100

SELECT 
	id,DATE_FORMAT(
		send_time,
		'%k'
	  ) send_time11,temp,ph,conductivity,oxygen,zhuodu
from daq_water_data WHERE year(send_time)=year(NOW()) AND MONTH(send_time)=MONTH(NOW()) and  DAY(send_time)=DAY(NOW())
 GROUP BY
	DATE_FORMAT(
		send_TIME,
		'%Y-%m-%d %k:00:00'
	)
ORDER BY
	send_time DESC Limit 100