兄弟,上次的确是错了我刚试了一下,发现这样可以: select BQZJJE from (select bqzjje from wzlsz order by bqzjje desc,ph) where rownum<=a and bqzjje not in (select bqzjje from (select bqzjje from wzlsz order by bqzjje desc,ph) where rownum<=N) 可是还是有一个问题,就是如果bzzjje在N与N+1一样时不正确。 我会再试试的。
如果你有一个唯一性字段,就好办了。 select BQZJJE from (select bqzjje,wzdm from wzlsz order by bqzjje desc) where rownum<=5 and wzdm not in (select wzdm from (select bqzjje,wzdm from wzlsz order by bqzjje desc ) where rownum<=10) 这样已经可以了,可选出第10到15的值.(wzdm是唯一的);
select BQZJJE from (select bqzjje from wzlsz order by bqzjje desc,ph) where rownum<=a
and bqzjje not in (select bqzjje from (select bqzjje from wzlsz order by bqzjje desc,ph) where rownum<=N)
可是还是有一个问题,就是如果bzzjje在N与N+1一样时不正确。
我会再试试的。
select BQZJJE from (select bqzjje,wzdm from wzlsz order by bqzjje desc) where rownum<=5
and wzdm not in (select wzdm from (select bqzjje,wzdm from wzlsz order by bqzjje desc ) where rownum<=10)
这样已经可以了,可选出第10到15的值.(wzdm是唯一的);