Posted on 2009-08-18 09:36
无很 阅读(109)
评论(0) 编辑 收藏
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