-
Notifications
You must be signed in to change notification settings - Fork 133
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
分页查询结果集有误 #8
Comments
是不是根据页数计算数据开始序号那有问题? |
@zsword 错的一塌糊涂啊! 现在想每页显示两条数据,根据sql语句,我从t_1表中查询出数据为1,3。t_2表查询出数据2,4。 翻第二也的时候。t_1查询出5,7。t_2查询出6,8。已经直接丢掉数据3和4了! 有没有什么好的算法? |
直接建试图,或者全部合并,再分页查询吧。 |
@zsword 在 2012-11-1 上午9:52,"周士淳" notifications@github.com写道:
|
作者这个问题最终怎么解决的? |
这个当前解决得怎么样了 |
这个问题在框架层面基本没有什么好的办法解决。有几种方案供大家参考: |
分页查询时可能出现结果集重复或者有些数据干脆取不出来的问题。通常会在最后一页较为多见。暂时还没有想到应对策略。
The text was updated successfully, but these errors were encountered: