解决方案
40
select id,content,user_id from ( select t1.*, (select count(*) from tb t2 where t1.user_id = t2.user_id and t1.id>=t2.id) rn from tb t1 )t where rn <= 2
CodeBye 版权所有丨如未注明 , 均为原创丨本网站采用BY-NC-SA协议进行授权 , 转载请注明请教mysql分组取出N条记录的方法！
40
select id,content,user_id from ( select t1.*, (select count(*) from tb t2 where t1.user_id = t2.user_id and t1.id>=t2.id) rn from tb t1 )t where rn <= 2
