mysql：

SELECT * from (SELECT H_TEMPERATURE FROM WENSHIDU 

WHERE TH_TIME >=date_sub(NOW(), interval 1 hour) AND TH_TIME<= NOW()

order by  TH_TIME desc ) as data limit 0,1;