SQL Server 分页方法

1. SELECT ROW_NUMBER() OVER (ORDER BY AddressID) AS RowNumber,* FROM test

2. SELECT TOP pagesize * FROM test
   WHERE AddressID > (SELECT MAX(AddressID) FROM ( SELECT TOP pagesize*(page-1) AddressID FROM test ORDER BY AddressID ) PRE) ORDER BY AddressID

3. SELECT TOP pagesize * FROM test
   WHERE AddressID NOT IN (SELECT TOP pagesize*(page-1) AddressID FROM test ORDER BY AddressID)
   ORDER BY AddressID