MySql、SQLServer 分页

select * from tb_test where id >=(select id from tb_test limit 90000,1) limit 100;

SELECT * FROM (SELECT TOP PageSize * FROM (SELECT TOP [PageIndex*PageSize] * FROM table ORDER BY id asc) as b ORDER BY id desc) as c ORDER BY id asc