17,382
社区成员




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