|
![做在线知识付费 选科汛云开店](http://www.kesion.com/images2015/ks_edu.jpg) SQL标签实现: SQL语句如下: ACCESS: - Select Top 6 ID,Title,AddDate From KS_Article Where ID Not In(Select Top 5 ID From KS_Article Order By ID) Order By ID
SQL数据库 >=SQL2005 用下面的: - Select Top 6 ID,Title,AddDate,ROW_NUMBER() Over(Order By ID) AS rn From KS_Article Where rn>5 Order By ID
|