用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
有猫相伴的日子 阅读(654)
评论(4) 编辑 收藏 所属分类:
pl/sql