第一种方式
SELECT
*
FROM
tablename AS a
WHERE
(SELECT
COUNT(*)
FROM
tablename AS b
WHERE
b.分类id = a.分类id AND b.id >= a.id) <= 5
ORDER BY a.分类id ASC , a.id DESC
第二种方式
SELECT
*
FROM
tablename AS a
WHERE
(SELECT
COUNT(*)
FROM
tablename AS b
WHERE
b.type = a.type AND b.id >= a.id) <= 5
ORDER BY a.type ASC , a.id DESC
mysql 取每个分类下的N条记录
最新推荐文章于 2024-07-22 03:10:33 发布