如题
select rn,num from (select rownum as rn ,num from (select * from test order by num)) where rn>=2 and rn<=5;
Oracle当从rownum的第二行起时候将无法查找到如何数据,只有通过别名。
如题
select rn,num from (select rownum as rn ,num from (select * from test order by num)) where rn>=2 and rn<=5;
Oracle当从rownum的第二行起时候将无法查找到如何数据,只有通过别名。