前言
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
更多推荐
MySQL实现分组排序并取组内第一条数据
发布评论