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