SELECT *
FROM (SELECT a.*, ROWNUM rn
FROM (SELECT * FROM zs_family) a
WHERE ROWNUM <= 40)
WHERE rn BETWEEN 21 AND 40;
FROM (SELECT a.*, ROWNUM rn
FROM (SELECT * FROM zs_family) a
WHERE ROWNUM <= 40)
WHERE rn BETWEEN 21 AND 40;