select top 1 m.Title , count(1) 评论次数, sum(n.Agree) 支持人数 , sum(n.DisAgree) 反对人数
from Article m , Comment n
where m.ArticleID = n.ArticleID
group by m.Title
order by 评论次数 desc;
[Quote=引用 1 楼 dawugui 的回复:]
SQL code
select top 1 m.Title , count(1) 评论次数, sum(n.Agree) 支持人数 , sum(n.DisAgree) 反对人数
from Article m , Comment n
where m.ArticleID = n.ArticleID
group by m.Title
order by 评论次数 desc
[/Quote]
+1
select top 1 m.Title , count(1) 评论次数, sum(n.Agree) 支持人数 , sum(n.DisAgree) 反对人数
from Article m , Comment n
where m.ArticleID = n.ArticleID
group by m.Title
order by 评论次数 desc
[Quote=引用 1 楼 dawugui 的回复:]
SQL code
select top 1 m.Title , count(1) 评论次数, sum(n.Agree) 支持人数 , sum(n.DisAgree) 反对人数
from Article m , Comment n
where m.ArticleID = n.ArticleID
group by m.Title
order by 评论次数 desc
[/Quote]