It looks like you wanna extract data between rownum 20 to 49, rite?
In a more simpler manner, i think the query should be like :
SELECT * FROM PRODUCT
WHERE ROWNUM BETWEEN 20 AND 49
ORDER BY CREATED DESC;
Try this and see. I don't think a sub-query is necessary.
This post has been edited by Marcus: Feb 24 2006, 12:01 AM
Oracle select statement