|
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
|