select Articleid,ArticleTitle from Article where Articleid in (select Articleid from (select top 10 Articleid, count(*) ReviewCount from Article_Review group by Articleid order by ReviewCount desc) t)
Create Procedure ArticleReview As Select Top 10 Article.Articleid, Article.ArticleTitle From Article, (SELECT Articleid, COUNT(Articleid) AS ArticleidCount FROM ArticleReview GROUP BY Articleid) AS ArticleReview2 Article.Articleid=ArticleReview2.Articleid Order By ArticleidCount;
Create Procedure ArticleReview As Select Top 10 Article.Articleid, Article.ArticleTitle From Article, (SELECT Articleid, COUNT(Articleid) AS ArticleidCount FROM ArticleReview GROUP BY Articleid) AS ArticleReview2 Article.Articleid=ArticleReview2.Articleid Order By ArticleidCount Desc;
Create Procedure ArticleReview As Select Top 10 Article.Articleid, Article.ArticleTitle From Article, (SELECT Articleid, COUNT(Articleid) AS ArticleidCount FROM ArticleReview GROUP BY Articleid) AS ArticleReview2 where Article.Articleid=ArticleReview2.Articleid Order By ArticleidCount Desc;少了个where
Create Procedure ArticleReview As Select Top 10 Article.Articleid, Article.ArticleTitle From Article, (SELECT Articleid, COUNT(Articleid) AS ArticleidCount FROM ArticleReview GROUP BY Articleid) AS ArticleReview2 where Article.Articleid=ArticleReview2.Articleid Order By ArticleidCount Desc;
Create Procedure ArticleReview As Select Top 10 Article.Articleid, Article.ArticleTitle From Article, (SELECT Articleid, COUNT(Articleid) AS ArticleidCount FROM ArticleReview GROUP BY Articleid) AS ArticleReview2 Article.Articleid=ArticleReview2.Articleid Order By ArticleidCount desc
where Articleid in (select Articleid from
(select top 10 Articleid, count(*) ReviewCount
from Article_Review group by Articleid
order by ReviewCount desc) t)
As
Select Top 10 Article.Articleid, Article.ArticleTitle
From Article,
(SELECT Articleid, COUNT(Articleid) AS ArticleidCount
FROM ArticleReview
GROUP BY Articleid) AS ArticleReview2
Article.Articleid=ArticleReview2.Articleid
Order By ArticleidCount;
As
Select Top 10 Article.Articleid, Article.ArticleTitle
From Article,
(SELECT Articleid, COUNT(Articleid) AS ArticleidCount
FROM ArticleReview
GROUP BY Articleid) AS ArticleReview2
Article.Articleid=ArticleReview2.Articleid
Order By ArticleidCount Desc;
As
Select Top 10 Article.Articleid, Article.ArticleTitle
From Article,
(SELECT Articleid, COUNT(Articleid) AS ArticleidCount
FROM ArticleReview
GROUP BY Articleid) AS ArticleReview2 where
Article.Articleid=ArticleReview2.Articleid
Order By ArticleidCount Desc;少了个where
As
Select Top 10 Article.Articleid, Article.ArticleTitle
From Article,
(SELECT Articleid, COUNT(Articleid) AS ArticleidCount
FROM ArticleReview
GROUP BY Articleid) AS ArticleReview2 where
Article.Articleid=ArticleReview2.Articleid
Order By ArticleidCount Desc;
As
Select Top 10 Article.Articleid, Article.ArticleTitle
From Article,
(SELECT Articleid, COUNT(Articleid) AS ArticleidCount
FROM ArticleReview
GROUP BY Articleid) AS ArticleReview2
Article.Articleid=ArticleReview2.Articleid
Order By ArticleidCount desc