What is the proper syntax for the Less Than/Equal operator in MyBatis 3? -
how use less equal in mybatis 3.
<select id="getlog" resultmap="baseresultmap" parametertype="java.lang.string"> select * from( select * table1 col1 =#{col1,jdbctype=varchar} order date desc ) table2 rownum <= 20 </select>
i show examples greater than/equal operator , less than/equal operators:
rownum >= 20 rownum <= 20
or, readability, can wrap them in cdata
rownum <![cdata[ >= ]]> 20 rownum <![cdata[ <= ]]> 20
Comments
Post a Comment