mysql分组取前几条记录
第一种方法
SELECT id, title, channel, create_time
FROM test_news AS a
WHERE ( SELECT count(1) FROM test_news AS b WHERE a.channel = b.channel AND a. STATUS = b. STATUS AND a.id < b.id ) < 5
ORDER BY a.channel ASC, a.id DESC;
第二种方法
SELECT a.id, a.titl.
原创
2021-06-26 14:50:31 ·
332 阅读 ·
0 评论