请高人指点－－怎样用sql语句返回表中第10-20条记录？？？

[atto]

怎样用sql语句返回表中第10-20条记录？？？

[bzszp]

select * from (select rownum id,tbname.* from tbname) where id>10 and id < 21;

[beckhambobo]

怎么老是如此多此类问题

[Croatia]

select * from tbname where rownum <21
minus
select * from tbname where rownum <11

[more_zou]

select * from tab where rownum between 11 and 21

[jlandzpa]

more_zou(小人物) :这样是不行的.
hehe

[more_zou]

惭愧！查了文档才知道搞错了，谢谢jlandzpa(jlandzpa) 兄提醒

[蓝诺]

我刚入门，，，学习