select* from(select a.*,ROWNUM rn from(SELECT NVL(APPLYBILLID,‘0’) as APPLYBILLID, NVL(COMPLETEBILLID,‘0’) as COMPLETEBILLID, NVL(FDID,‘0’) as FDID,NVL(FDCONFIRMID,‘0’) as FDCONFIRMID,NVL(ZZVALUEID,‘0’) as ZZVALUEID,SHIPPINGORDERKEY, BUSINESSNO, to_char(TRANSITDATE, ‘yyyy-MM-dd’) as TRANSITDATE, BLNO, DATATYPE,LOADINGPORTCODE, DESTINATIONPORTCODE, SECONDCARRIER, SECONDVESSELNAMEEN, SECONDVOYAGENO from F_SHIPPINGORDER where SHIPPERREGNO=:shipperRegno order by TRANSITDATE desc) a where ROWNUM <=:listend) where rn>:liststart
oracle分页语句
最新推荐文章于 2024-08-19 08:45:16 发布