select t.user_id, t.money from (select ord.user_id, ord.money, ord.create_time from orders ord where ord.user_id > 0 and create_time > 0 order by user_id asc , create_time desc) t group by user_id ;
看了好多文章,这篇解决了我的问题,感谢博主。Mysql 分组聚合实现 over partition by 功能
暂存,有时间再整理