81,092
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM (
SELECT t.*, row_number() OVER(ORDER BY id) AS rn FROM t_mt_stat t
) x
WHERE x.rn BETWEEN 11 AND 20
SELECT * FROM (
SELECT t.*, rownum rn FROM (
SELECT * FROM t_mt_stat ORDER BY id
) t
WHERE rownum <= 20
) x
WHERE x.rn >= 11
private int itemTotalCount;
private int perPage;
private int currentPageIndex = 0;
private int nextPage;
private int previousPage;
private boolean existNextPage;
private boolean existPreviousPage;
private ArrayList pageList = null;