如何配置mybatis的SQL语句

Question

比如我要写入这条语句的话，如何配置XML
SELECT * FROM (SELECT * FROM WARNING_RECORD ORDER BY CREATE_TIME DESC )

WHERE ROWNUM <= 5

Answer 1

<!-- 将特殊的符号（标签开始和结束的尖括号）转换成 SQL的语句 -->
<![CDATA[
SELECT * FROM (SELECT * FROM WARNING_RECORD ORDER BY CREATE_TIME DESC )
WHERE ROWNUM <= 5

]]>