oracle查询某列某个区间的值

SELECT * FROM (SELECT ROWNUM ro, TCQBM,grbh,xm,zjlx,zjhm,xzlxdm,rycbztdm,cbksrq,cbzzrq,tcqmc  FROM cbrcbxx) WHERE ro>=300000 AND ro<600000