select * from
(select c1,c2,rownum as r,rowid from table where rownum<=20)
r>=11这句话报错,rowid 处有问题,请问这么能够同时查询出rowid,谢谢
(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 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
SELECT empno,ename,ID FROM
(SELECT t.empno,t.ename,ROWNUM rn,ROWID ID FROM emp t
WHERE ROWNUM<14)
WHERE rn>10
rowid没有给别名而出错了,rowid修改为rowid "rowid"即可,感谢大家的帮助