oracle中使用
select * from (select a.*,ROWNUM rn from (select * from 表名 where t.flag=1) a ) where RN>=开始的行数 and RN<结束的行数
例如:select * from (select a.*,ROWNUM rn from (select * from prj t where t.flag=1) a ) where RN>=10 and RN<20
sqlserver 使用
select * from (select Row_Number() over(Order by id) as RowId ,* from 表名) U where U.RowId between 开始的行数 and 结束的行数
例如:select * from (select Row_Number() over(Order by id) as RowId ,* from tbl_userinfo) U where U.RowId between 0 and 20s