如题
select t.*,rownum r from test t where r>50 and r<=100;
网上有这么说的,但是我执行是报错
select * from test where rownum < 10;
是查询前十条
select t.*,rownum r from test t where r>50 and r<=100;
网上有这么说的,但是我执行是报错
select * from test where rownum < 10;
是查询前十条
select * from(select t.*,rownum r from test t) where r>50 and r<=100;
select *
from (select t.*,rownum r from test t) a where r>50 and r<=100;