mybatis xml分页报错！！

Question

select * from(select a1.*,rownum rn from (select * from course)a1 where rownum<#{max})where rn>#{min}

左边有两个×；

The content of elements must consist of well-formed character data or markup.

Answer 1

SELECT * FROM (
SELECT ed.*,ROWNUM rn FROM
(SELECT * FROM emp e INNER JOIN dept d ON e.deptno=d.deptno


e.ename LIKE #{eename}


and e.hiredate<![CDATA[>]]>to_date(#{ehiredate},'yyyy-MM-dd')


and d.dname LIKE CONCAT(CONCAT('%',#{edname}),'%')


) ed) de
WHERE de.rn<![CDATA[>]]>#{pageIndex1} AND de.rn<![CDATA[<]]>=#{pageIndex2}

</select>