数据表如下:
mysql查询发帖数前三的用户名:
select username,count(username) as number from posts group by username order by number desc limit 3
数据表如下:
mysql查询发帖数前三的用户名:
select username,count(username) as number from posts group by username order by number desc limit 3