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 &gt;= 20 rownum &lt;= 20 

or, readability, can wrap them in cdata

rownum <![cdata[ >= ]]> 20 rownum <![cdata[ <= ]]> 20 

Comments

Popular posts from this blog

dns - How To Use Custom Nameserver On Free Cloudflare? -

python - Pygame screen.blit not working -

c# - Web API response xml language -