文章详情

  • 游戏榜单
  • 软件榜单
关闭导航
热搜榜
热门下载
热门标签
php爱好者> php文档>sql server limit 使用

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
相关阅读 更多 +
排行榜 更多 +
辰域智控app

辰域智控app

系统工具 下载
网医联盟app

网医联盟app

运动健身 下载
汇丰汇选App

汇丰汇选App

金融理财 下载