原来的sql分页查询语句
select * from table order by id desc limit 1000000,10;
第一种方式
select * from table where id > (select id from table ORDER BY id desc limit 1000000, 1) ORDER BY id desc limit 0, 10;
第二种方式
select * from table a,(select id from table limit 1000000,10) b where a.id=b.id order by id desc;