用rownum實(shí)現(xiàn)大于、小于邏輯（返回rownum在4—10之間的數(shù)據(jù)）（minus操作，速度會(huì)受影響）?
select rownum,month,sell from sale where rownum<10?
minus?
select rownum,month,sell from sale where rownum<5;?
返回第5—9條紀(jì)錄，按月份排序?
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
有貓相伴的日子 閱讀(666)
評(píng)論(4) 編輯 收藏 所屬分類:
pl/sql