就是这个取6-10位数据
select * from ( select e.*,rownum rn from (select * from emp) e where rownum<10) where rn>6;如果要写成
select e.*,rownum rn from (select * from emp) e where rownum<10 and rn>6; 就会报错
请高手解答一下为什么
select * from ( select e.*,rownum rn from (select * from emp) e where rownum<10) where rn>6;如果要写成
select e.*,rownum rn from (select * from emp) e where rownum<10 and rn>6; 就会报错
请高手解答一下为什么
select * from ( select e.*,rownum rn from (select * from emp) e where rownum<10) where rn>6;
这样,再包一层。
和
from emp有什么不同?,为啥这样写呢
//可以改成
select * from ( select e.*,rownum rn from emp e where rownum<10) where rn>6;
只能这样。
6-10位数据
select * from ( select e.*,rownum rn from (select * from emp) e where rownum<10) where rn>=6;