SELECT *
FROM (SELECT ROWNUM AS ROWINDEX,
CARRYID,
CARRYCODE,
CARRYNAME,
CARRYDESC,
CARRYZJM,
INPUTOR,
INPUTDATE,
STAGE,
AUDITOR,
AUDITDATE,
FORGID,
FRCODE
FROM HIS.ECHOCARRY where 1=1 )
WHERE 1 = 1
AND ROWINDEX BETWEEN 10 AND 20
Oracle 分页
最新推荐文章于 2023-06-14 09:30:41 发布