derby分页语句

wxq594808632

SELECT * FROM ( SELECT ROW_NUMBER() OVER() AS rownum, mytable.* FROM mytable) AS tmp WHERE rownum <= 9 and rownum>6;  
从第六条数据到第九条