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??
有人知道不?
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??
有人知道不?
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