order by 失效问题

https://blog.youkuaiyun.com/u013066244/article/details/116461584

select * FROM
(SELECT end_time,end_flow,device_no FROM water_consumption_day_record_5
WHERE month = 202212 
order BY device_no,end_time desc)  a 
GROUP BY a.device_no

先排序再分组取分组的第一个

失效原因：https://blog.youkuaiyun.com/u013066244/article/details/116461584

修改：

select * FROM

(SELECT DISTINCT(id),end_time,end_flow,device_no FROM water_consumption_day_record_5

WHERE month = 202212

order BY device_no,end_time desc) a

GROUP BY a.device_no