SELECT
*
FROM
(
SELECT
A .*,
ROWNUM row_num
FROM
(
select *from users
) A
WHERE
ROWNUM < pageNo*pageSize+1
) b
WHERE row_num >
*
FROM
(
SELECT
A .*,
ROWNUM row_num
FROM
(
select *from users
) A
WHERE
ROWNUM < pageNo*pageSize+1
) b
WHERE row_num >
(pageNo-1)*pageSize
pageNo-1*pageSize
pageNo*pageSize+1