17,086
社区成员
发帖
与我相关
我的任务
分享
select * from (select t.*,rownum from MBAA01_OW_OWNER t WHERE 1=1 )
where rownum > 0 AND rownum <= 5
select * from (select t.*,rownum from MBAA01_OW_OWNER t WHERE 1=1 )
where rownum > 5 AND rownum <= 10
--
select * from (select rownum num,t.* from MBAA01_OW_OWNER t WHERE 1=1 )
where rownum > 0 AND rownum <= 5
--指定伪列别名
select * from (select rownum num,t.* from MBAA01_OW_OWNER t WHERE 1=1 )
where num > 5 AND num <= 10