wxq594808632 发表于 2013-1-14 23:04:12

derby分页语句

SELECT * FROM ( SELECT ROW_NUMBER() OVER() AS rownum, mytable.* FROM mytable) AS tmp WHERE rownum <= 9 and rownum>6;  
从第六条数据到第九条
页: [1]
查看完整版本: derby分页语句