获得分组内容的前N条记录
实现效果: 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 A
原创
2011-03-19 20:34:00 ·
751 阅读 ·
0 评论