SQL 分页

sql = "SELECT TOP 10000 * " +
" FROM(SELECT ROW_NUMBER() OVER(ORDER BY DataArticleID) AS RowNumber, *FROM( ";

。。。。。。

sql += ")table1 ) as A " +
" WHERE RowNumber > 0 ";

posted on 2016-10-21 10:33  Riusmary  阅读(81)  评论(0编辑  收藏  举报

导航