读书人

oracle分页查询时这样能同时得到row

发布时间: 2013-03-26 09:54:34 作者: rapoo

oracle分页查询时,这么能同时得到rowid?
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

读书人网 >oracle

热点推荐