实现效果: SELECT Authorid,Author,Message FROM ( SELECT A.Authorid,A.Author,A.Message, IF(@Author=A.Author,@rank:=@rank+1,@rank:=1) AS rank, @Author:=A.Author FROM ( SELECT Authorid,Author,Message FROM t_authorm ORDER BY Authorid ASC ) A ,(SELECT @Author:= NULL ,@rank:=0) B ) M WHERE M.rank<3