原帖由 王亮 于 2011-07-19 12:29 发表 select * from (select e.*,rownum rn from emp e) a1 where a1.rn between 6 and 10;
请问这是oracle吗?oracle貌似没有between的用法。oracle好像是:
select * from (select e.*,rownum rn from emp e where rownum 数字2
关键是rownum要有别名。
谁说oracle没有between用法的·· |
|