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;
转载于:https://www.cnblogs.com/Stephenchao/p/5213281.html
分页索引
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;
转载于:https://www.cnblogs.com/Stephenchao/p/5213281.html
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
