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