10,606
社区成员
发帖
与我相关
我的任务
分享xml里面sql 的where语句中<=无法识别
<sql>
<isNotEmpty prepend="and" property="NOTE_TYP">
T.NOTE_TYP = #NOTE_TYP#
</isNotEmpty>
<isNotEmpty prepend="and" property="ROWNUM">
<![CDATA[
ROWNUM <= #ROWNUM#
]]>
</isNotEmpty>
</sql>
[EBUG]-[2014-03-24 15:12:46.380] http-8081-1 Connection:27 [{conn-100015} Preparing Statement: SELECT * FROM (SELECT * FROM MMP.P_SYS_NOTE ORDER BY VALID_DATE DESC) WHERE ROWNUM < ? ]
为什么不是<=而是<呢？？？
<isNotEmpty prepend="and" property="NOTE_TYP">
T.NOTE_TYP = #NOTE_TYP#
</isNotEmpty>
<isNotEmpty prepend="and" property="ROWNUM">
<![CDATA[
ROWNUM <= #ROWNUM#
]]>
</isNotEmpty>
</sql>
[EBUG]-[2014-03-24 15:12:46.380] http-8081-1 Connection:27 [{conn-100015} Preparing Statement: SELECT * FROM (SELECT * FROM MMP.P_SYS_NOTE ORDER BY VALID_DATE DESC) WHERE ROWNUM < ? ]
为什么不是<=而是<呢？？？
...全文
请发表友善的回复…
发表回复
