[https://www.zhihu.com/question/327253526](https://www.zhihu.com/question/327253526) Top1 查文章列表分頁并附帶各自評論數點贊數最高的評論 ``` SELECT a.*,b.max_score from sc a INNER JOIN ( SELECT CId,max(score) max_score from sc GROUP BY CId ) b on a.CId= b.CId and a.score= b.max_score; ``` TopN 查文章列表分裂并附帶各自評論數點贊數前5的評論 ``` select * from comment c where parent_id in ({ids}) and (select count(*) from comment s where c.parent_id = s.parent_id and c.created_at < s.created_at) < 5 ```