使用場景:為了獲取工單的最新的一條數據砸彬,按order by再group by的時候獲取的最舊的,不是要的效果
故:
select * from ticket_remark?
where id in (select SUBSTRING_INDEX(group_concat(id order by `id` desc),',',1) from `ticket_remark` group by ticket_id)?
and label = '0101050000'?
order by `id` desc