sql server limit 使用

dianyu7172

于 2010-09-25 18:54:00 发布

阅读量1.2k

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/JemBai/archive/2010/09/25/1834803.html

版权

本文介绍了一种复杂的SQL查询方法，通过使用子查询和联表查询来获取特定的数据集合。该查询旨在排除最近发布的文章并按发布时间降序排列。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

转载于:https://www.cnblogs.com/JemBai/archive/2010/09/25/1834803.html