mysql 使用group by 语句获取分组后,最新的时间的数据
先看表中的数据
获取同一个articelid下的最新的审核状态
sql语句:
select * from check_info where id in (select substring_index(group_concat(id order by checktime desc),',',1) as checkid from check_info group by articleid )
先看表中的数据
获取同一个articelid下的最新的审核状态
sql语句:
select * from check_info where id in (select substring_index(group_concat(id order by checktime desc),',',1) as checkid from check_info group by articleid )