SELECT * from t_comment a where ( SELECT count(1) from t_comment b where b.theme_id=a.theme_id and b.id > a.id )<2 and a.theme_id in (1,2,3) order by a.theme_id, a.comment_date desc; 查询某几条帖子的前几条评论;id为主键id,theme_id为帖子id 示例:查询了三个帖子的各自的最新2条评论