MySQL实现分组排序并取组内第一条数据

前言

MySQL分组取组内第一条数据

---

代码实现–这种❌

SELECT
	* 
FROM
	cl_Issue_accessory 

GROUP BY
	type_id 
ORDER BY
	end_time DESC

select * from cl_Issue_accessory where type_id =2 ORDER BY end_time DESC

检查一下时间排序：

真正的分组，取数据

select t.* from (
    select * from cl_Issue_accessory cia order by cia.end_time desc  limit 1000
) t group by t.type_id