分页索引

start = ((start - 1) * n + 1);
int end = (start + n - 1);
sql = "WITH T AS(" + sql + ") SELECT * FROM T WHERE T.rownum BETWEEN " + start + " AND " + end;

posted on 2016-02-24 15:53  Stephen_潮  阅读(356)  评论(0编辑  收藏  举报