MYSQL、ORACLE、SQLSERVER获取行号，增量查询

oracle
select * from (
select rownum as rn,HDMS.HD_PURGE_STATUS.* from HDMS.HD_PURGE_STATUS
where rownum <=) where rn> and rn<=;
SqlServer
select * from (
select * from (select row_number()over(order by tempcolumn)temprownumber,* from
 (select top  tempcolumn=,* from testdm.dbo.books)t
 )tt where temprownumber>) YY;
 
MySQL
select * from sakila.actor limit ,;
数据量大时，2个参数limit性能有影响，用如下：vid是表中一列
Select * From yanxue8_visit Where vid >=(
Select vid From yanxue8_visit Order By vid limit ,
) limit