`
wuhen86
  • 浏览: 13441 次
  • 性别: Icon_minigender_1
  • 来自: 郑州
最近访客 更多访客>>
社区版块
存档分类
最新评论

Oracle 分页

阅读更多

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

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics