第一句SQL:
select s.* from ( select this_.STCD as STCD1_0_, this_.TM as TM1_0_ from ST_RIVER_R this_ order by this_.TM desc ) s where ROWNUM>0 AND rownum <= 10
第二句SQL:
select s.* from ( select this_.STCD as STCD1_0_, this_.TM as TM1_0_ from ST_RIVER_R this_ order by this_.TM desc ) s where rownum <= 10
如上述,查询出的解决竟然有所不同,查询期间未有任何的填删改操作,希望大家能帮忙给个解释谢谢!!!!!
select s.* from ( select this_.STCD as STCD1_0_, this_.TM as TM1_0_ from ST_RIVER_R this_ order by this_.TM desc ) s where ROWNUM>0 AND rownum <= 10
第二句SQL:
select s.* from ( select this_.STCD as STCD1_0_, this_.TM as TM1_0_ from ST_RIVER_R this_ order by this_.TM desc ) s where rownum <= 10
如上述,查询出的解决竟然有所不同,查询期间未有任何的填删改操作,希望大家能帮忙给个解释谢谢!!!!!
解决方案 »
- js循环输出set里的对象
- java多线程问题!!给我看看这个程序!
- 请教一个奇怪的问题, ie影响service调用速度
- hibernate
- 跨库调用存储过程,并希望高手能讲下关于存储过程相关知识。。
- 一个关于velocity模板的语法问题
- webwork中的一个奇怪现象!!
- lookup找不到对象?!!
- java 中怎样调用另一个程序中的类
- ■■请问高手,在哪里可以根据表的字段名自动生成get set 方法???jbuilder?
- Jedis如果在value中存储Object对象
- 发生ActionScript错误 SecurityError: Error #2000: 没有活动的安全上下文。
所以强调不能直接用rownum进行分页,必须先固化,再分页!select s.* from (
select this_.STCD as STCD1_0_, this_.TM as TM1_0_, rownum as rn_ from ST_RIVER_R this_ order by this_.TM desc
) s
where rn_>0 AND rn_<= 10