select * from amis_change_mail AS x where update_time = (select max(update_time) from amis_change_mail AS y where x.apply_user=y.apply_user AND x.apply_user=32);
选取最近的一条记录
最新推荐文章于 2024-06-30 21:16:43 发布
select * from amis_change_mail AS x where update_time = (select max(update_time) from amis_change_mail AS y where x.apply_user=y.apply_user AND x.apply_user=32);