数据库分页SQL

Oracle分页：

SELECt *
  FROM (SELECt A.*, ROWNUM AS RN
          FROM (SELECt *
                  FROM ORDER_FROM
                 WHERe orderNo = '80222101210'
                 ORDER BY TC_OD_ID DESC) A
         WHERe ROWNUM <= 32)-- #{pageNum:页码} * {pageSize:每页大小}
 WHERe RN > 0 -- #{paegNum -1} * #{pageSize}
   AND orderNo = '80222101210'

Mysql分页：

        select * from chgoptdtl where name='188096' and codId >=(select codId from chgoptdtl where name='188096' limit 1000,1) limit 200