mysql没有partition by 怎么实现分组取第一行呢

直接上代码：有时间在研究吧

SELECT TABLE_NAME,SUBSTRING_INDEX(GROUP_CONCAT(id ORDER BY id DESC ),',',1)
FROM mgr_table
WHERE upper(TABLE_NAME) in 
('')
group by table_name