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.
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>