select * from
（select c1,c2,rownum as r,rowid from table where rownum<=20)
r>=11
这句话报错，rowid 处有问题，请问这么能够同时查询出rowid，谢谢
------解决方案--------------------
select * from
（select c1,c2,rownum as r,rowid "rowid" from table where rownum<=20)
where r>=11
------解决方案--------------------
select * from
（select c1,c2,rownum as r,rowid "rowid" from table where rownum<=20)
where r>=11
或者
select * from
（select c1,c2,rownum as r,rowid ss from table where rownum<=20)
where r>=11