Chinaunix

标题: 常用mysql语句备忘 [打印本页]

作者: sdtuzi 时间: 2011-12-20 09:46
标题: 常用mysql语句备忘
SELECT `author` , `authorid` , count( * ) AS times
FROM `pre_forum_post`
GROUP BY `author`
ORDER BY times DESC
LIMIT 0 , 5

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)