SELECT TOP 页大小 * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber,* FROM table1 ) AWHERE RowNumber > 页大小*(页数-1)
sql 分页
原文：http://www.cnblogs.com/hellowzd/p/4279181.html
