17,377
社区成员
发帖
与我相关
我的任务
分享
select * from (select a1.*,rownum rn from (select * from emp )a1 where rownum<=10) where rn>=6;
--是不是一定得起别名?
select * from (select a1.*,rownum rn from (select * from emp )a1 where rownum<=10) where rownum>=6;
--这样不行吗?
select * from (select a1.*,rownum from (select * from emp )a1 where rownum<=10) where rownum>=6;
--这样也不行?