用rownum實現大于、小于邏輯（返回rownum在4—10之間的數據）（minus操作，速度會受影響）?
select rownum,month,sell from sale where rownum<10?
minus?
select rownum,month,sell from sale where rownum<5;?
返回第5—9條紀錄，按月份排序?
select * from (select rownum row_id ,month,sell
from (select month,sell from sale group by month,sell))?
where row_id between 5 and 9;
posted on 2006-04-03 15:55
有貓相伴的日子 閱讀(669)
評論(4) 編輯 收藏 所屬分類:
pl/sql