方法一:group by
mysql> select count(*) as num,aid from comment group by aid order by num;
+-----+-----+
| num | aid |
+-----+-----+
| 2 | 10 |
| 3 | 9 |
+-----+-----+
2 rows in set
mysql>
方法二:在文章表中新建一个字段保存评论数量
方法一:group by
mysql> select count(*) as num,aid from comment group by aid order by num;
+-----+-----+
| num | aid |
+-----+-----+
| 2 | 10 |
| 3 | 9 |
+-----+-----+
2 rows in set
mysql>
方法二:在文章表中新建一个字段保存评论数量
本文标题:文章按照评论数数量排序
本文链接:https://www.haomeiwen.com/subject/chmedltx.html
网友评论