这个语句该怎么写

[liujiwe79]

我想从一个表中取出从第10行到20行的数据，我用
select * from jjaj where rownum >10 and rownum<20;
为什么取不出数据，请帮忙！

[jiezhi]

use function minus:
select * from jjaj where rownum<=20
minus
select * from jjaj where rownum<10

[liujiwe79]

select rownum from jjaj where rownum <=3 minus
select rownum from jjaj where rownum >2 ;

这条语句为什么还能把rownum＝2的选择出来：

[Lastdrop]

因为rownum==2的记录不在集合select rownum from jjaj where rownum >2 中，此集合中最小的rownum是3!

[developer2002]

select rownum from jjaj where rownum >2 根本就不会返回任何结果，当然有rownum＝2的了。因为满足select rownum from jjaj where rownum <=3 。懂了吧

[w_tsinghua]

select * from (select a.*,rownum as id from jjaj a) where id between 10 and 20;