SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
WHERE RN<= (pageIndex+1)*pageSize
)
WHERE RN >= pageIndex*pageSize
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
WHERE RN<= (pageIndex+1)*pageSize
)
WHERE RN >= pageIndex*pageSize