sql server limit 使用
时间:2010-09-25 来源:草原和大树
SELECT TOP (5) ExTable, ColumnId, RecommandType, ArticleId, Name, SubName, Summary, Author, Inputdate, PublishDate, Status, UserId, ArticleTypeId,
Sequence, Appendix, SummaryPicture, Keyword, JournalSubName, Dept
FROM CMS_vArticle
WHERE (ColumnId = '664') AND (Status = '2') AND (ArticleId NOT IN
(SELECT TOP (1) ArticleId
FROM CMS_vArticle AS CMS_vArticle_1
WHERE (ColumnId = '664') AND (Status = '2')
ORDER BY PublishDate DESC))
ORDER BY PublishDate DESC
Sequence, Appendix, SummaryPicture, Keyword, JournalSubName, Dept
FROM CMS_vArticle
WHERE (ColumnId = '664') AND (Status = '2') AND (ArticleId NOT IN
(SELECT TOP (1) ArticleId
FROM CMS_vArticle AS CMS_vArticle_1
WHERE (ColumnId = '664') AND (Status = '2')
ORDER BY PublishDate DESC))
ORDER BY PublishDate DESC
相关阅读 更多 +