求每个user_name的最新create_time
select a.* from sys_log as a where create_time = (select max(create_time) from sys_log where user_name = a.user_name) order by a.user_name
mysql分组求最大数据
最新推荐文章于 2024-07-22 02:59:37 发布
求每个user_name的最新create_time
select a.* from sys_log as a where create_time = (select max(create_time) from sys_log where user_name = a.user_name) order by a.user_name