oracle 分页demo
SELECT *
FROM (SELECT a.*, ROWNUM rn
FROM (SELECT * FROM zs_family) a
WHERE ROWNUM <= 44)
WHERE rn BETWEEN 13 AND 44;
SELECT *
FROM (SELECT a.*, ROWNUM rn
FROM (SELECT * FROM zs_family) a
WHERE ROWNUM <= 44)
WHERE rn BETWEEN 13 AND 44;