oracle数据库中，下面的语句为什么查不出数据? select * from roadline where 1<rownum and rownum <3

---

rownum是隐含字段，他是在结果集中过坦陆孙滤的，所以不让链能使用范围
只能悉晌rownum=1,或rownum<某个值

---

不能渣让用rownum > 一察升个数 的
你如没局可以改为：
select * From (select t.*, rownum as row_num from roadline t where rownum < 3) where row_num > 1

---

--这样写耐源 你的写昌燃态法有问题
select * from (
select roadline.*,rownum bz from roadline) aa where bz>1 and bz <段茄3

---

select * From (select t.*, rownum as row_num from roadline t where rownum <谨帆 3) where row_num >毕晌仿手纤 1

---

select t2.*
from (select rownum r,t1.* from roadline t1 where rownum<逗笑缺山辩升数3) t2
where t2.r>1

---