oracle select * from ( select rownum as rn,HDMS.HD_PURGE_STATUS.* from HDMS.HD_PURGE_STATUS where rownum <=20) where rn>10 and rn<=20; SqlServer select * 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; MySQL select * 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