SELECT `author` , `authorid` , count( * ) AS times
FROM `pre_forum_post`
GROUP BY `author`
ORDER BY times DESC
LIMIT 0 , 5
mysql语句备忘
最新推荐文章于 2024-08-29 18:50:28 发布
SELECT `author` , `authorid` , count( * ) AS times
FROM `pre_forum_post`
GROUP BY `author`
ORDER BY times DESC
LIMIT 0 , 5