sql - 如何获得有评论的新闻？

Question

我想按总评论的顺序获取评论的新闻，

我尝试这个 SQL 代码

SELECT COUNT( comment ) , N . * , C . * 
FROM news N, comment C
WHERE N.ID = C.ID_NEWS

但问题是它只返回所有评论总数的第一个新闻

有什么解决办法吗？

标签： sql

Answer 1

我想你想要这样的查询：

SELECT N.ID as comments_order, 
       count( C.comment ) as total_comments
  FROM news N INNER JOIN comment C
    ON (  N.ID = C.ID_NEWS )
 GROUP BY N.ID
 ORDER BY total_comments;