Thursday, September 30, 2010

No no no - SQL paging in oracle - It cant be

SELECT * FROM (
SELECT t1.*, ROWNUM rnum
FROM your_table t1
WHERE t1.name = ? ORDER BY t1.name DESC)
WHERE rnum >=? AND rownum <= ?


You got to be kidding me is there not an easy way like limit in mysql

No comments:

Post a Comment