摘要： select * from user where xx=1 limit 10,10你需要有ORDER　BY 字段。 然后需要 （xx, orderCol) 的复合索引，再使用select * from user a inner join (select id from user where xx=1 order by id limit 10,10) b using(id)select * from emp where deptno = 20 limit 900000,3;ysql> alter table emp add index(deptno,empno);uery OK, 0 ro 阅读全文