本文章给大家介绍mysql获取所有分类和每个分类的前n条记录,article(id,category,insertdate)，现在要用sql找出每种类型中时间最新的前n个数据组成的集合，一段不错的代码
代码如下 复制代码
select a1.*
from article as a1
inner join (select a.category,a.insertdate
from article as a
left join article as b
on a.category = b.category
and a.insertdate group by a.category,a.insertdate
having count(b.insertdate) ) as b1
on a1.category = b1.category
and a1.insertdate = b1.insertdate
order by a1.category,a1.insertdate desc