select * from (
select t.* ,ROWNUM as rn from (
SELECT b.FNAME_L2,c.FALIAS_L2 FROM T_PM_RolePerm a left join T_PM_Role b on b.FID =a.FROLEID left join T_PM_PermItem c on a.FPERMITEMID =c.fid where b.FNAME_L2 is not null) t
where ROWNUM <= 40)
where rn >30;
select t.* ,ROWNUM as rn from (
SELECT b.FNAME_L2,c.FALIAS_L2 FROM T_PM_RolePerm a left join T_PM_Role b on b.FID =a.FROLEID left join T_PM_PermItem c on a.FPERMITEMID =c.fid where b.FNAME_L2 is not null) t
where ROWNUM <= 40)
where rn >30;