select TOP 10 ArticleID,ArticleMode,ArticleText,ArticleCategoryID ,ArticleTitle,CreateTime from tblArticle WHERE ArticleCategoryID='C1' ORDER BY CreateTime DESC
加了ORDER BY CreateTime DESC TOP 10 这句话等于无效?
那该怎么办?
...全文
252打赏收藏
为什么TOP 10 关键字无效?
select TOP 10 ArticleID,ArticleMode,ArticleText,ArticleCategoryID ,ArticleTitle,CreateTime from tblArticle WHERE ArticleCategoryID='C1' ORDER BY CreateTime DESC 加了ORDER BY CreateTime DESC TOP 10 这句话等于无效? 那该怎么办?
是否
select TOP 10 ArticleID,ArticleMode,ArticleText,ArticleCategoryID ,ArticleTitle,CreateTime from tblArticle WHERE ArticleCategoryID='C1' ORDER BY CreateTime DESC
和
select ArticleID,ArticleMode,ArticleText,ArticleCategoryID ,ArticleTitle,CreateTime from tblArticle WHERE ArticleCategoryID='C1' ORDER BY CreateTime DESC