每页1条记录，第二页
WITH query AS (SELECT TOP 100 PERCENT ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) as row_number, id,account,passworld,name,sex,phone,email,qq,status,departmentid FROM sys_user) SELECT * FROM query WHERE row_number BETWEEN 1 AND 2 ORDER BY row_number

每页两条记录，第二页
WITH query AS (SELECT TOP 100 PERCENT ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) as row_number, id,account,passworld,name,sex,phone,email,qq,status,departmentid FROM sys_user) SELECT * FROM query WHERE row_number BETWEEN 2 AND 4 ORDER BY row_number