17,377
社区成员
发帖
与我相关
我的任务
分享
1.SELECT *
2. FROM (Select ROWNUM AS ROWNO, T.*
3. from k_task T
4. where Flight_date between to_date('20060501', 'yyyymmdd') and
5. to_date('20060731', 'yyyymmdd')
6. AND ROWNUM <= 20) TABLE_ALIAS
7.WHERE TABLE_ALIAS.ROWNO >= 10;
select * from (select * from work_task where rownum<=10)
where rownum>5