select的问题

[wenyongjie]

select t.fname,t.cardno,t.iccardid,t.stime,t.etime,t.distime,t.imgpath,t.sn,t.name,t.idcard,t.enterpriseid,t.enterprise,t.vehicleoid, b.frq
from xyreportmx t
inner join xyreporthz b on t.fname=b.fname
inner join v_vehiclelaststatusposition v on t.vehicleoid=v.VEHICLEOID
where b.fname is not null and t.fname is not null
and b.mxcount=b.insertcount
and t.isdelete='0'and t.reporttype='1'and t.signature_one='已签章'
and t.idcard is not null and t.enterpriseid is not null and t.vehicleoid is not null
and t.etime<v.GPSDATETIME
and t.is_do is null and rownum<100

显示前面100条记录，我只想显示 50-70之间的记录，要怎么改rownum<100??
有人知道不？

[Kobayashi]

select * from (select t.fname,t.cardno,t.iccardid,t.stime,t.etime,t.distime,t.imgpath,t.sn,t.name,t.idcard,t.enterpriseid,t.enterprise,t.vehicleoid, b.frq,rownum hs from xyreportmx t inner join xyreporthz b on t.fname=b.fname inner join v_vehiclelaststatusposition v on t.vehicleoid=v.VEHICLEOID where b.fname is not null and t.fname is not null and b.mxcount=b.insertcount and t.isdelete='0'and t.reporttype='1'and t.signature_one='已签章' and t.idcard is not null and t.enterpriseid is not null and t.vehicleoid is not null and t.etime<v.GPSDATETIME and t.is_do is null) t where t.hs between 70 and 100