select r.,MAX(r.value
) as max,MIN(r.value
) as min from
(select a. from point_data a where a.kongzhi = ‘1’ ORDER BY a.time desc LIMIT 18446744073709551615)r
GROUP BY r.pointid ORDER BY r.time desc
GROUP BY ORDER BY 同时存在时
LIMIT 18446744073709551615 这个如果不附带、则只执行的只是随机的 GROUP BY 则不会按照时间倒序进行排列、执行的是随机时间。