[size=x-small] <!-- mybatis oracle分页查询 -->
<select id="getAllMsgByMlh" resultType="java.util.HashMap">
SELECT *
FROM (SELECT A.*, ROWNUM RU
FROM (SELECT ASJBH,
PAGENUM
FROM jz_dzjz_list
WHERE JZMLH = '${jzmlh}'
ORDER BY START_PAGE) A
where ROWNUM <![CDATA[ < ]]> '${end}')
WHERE RU >= '${start}'
</select>[/size]
<select id="getAllMsgByMlh" resultType="java.util.HashMap">
SELECT *
FROM (SELECT A.*, ROWNUM RU
FROM (SELECT ASJBH,
PAGENUM
FROM jz_dzjz_list
WHERE JZMLH = '${jzmlh}'
ORDER BY START_PAGE) A
where ROWNUM <![CDATA[ < ]]> '${end}')
WHERE RU >= '${start}'
</select>[/size]