SELECT * FROM
(
SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLENAME order by TIME desc) A WHERE ROWNUM <=1*5
)
WHERE RN > (1-1)*5
(
SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLENAME order by TIME desc) A WHERE ROWNUM <=1*5
)
WHERE RN > (1-1)*5