先看表中的数据
获取同一个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 )