<select id="getDataList" resultMap="BaseResultMap">
SELECT
*
FROM
(
SELECT
TMP_PAGE.*,
ROWNUM ROW_ID
FROM
(
#查询语句
SELECT * FROM TABLE
)TMP_PAGE
WHERE ROWNUM <![CDATA[ < ]]> ((#{pageNum} + 1) * #{pageSize} + 1)
)
WHERE ROW_ID <![CDATA[ > ]]> ((#{pageNum} + 1) * #{pageSize} - #{pageSize})
</select>
oracle分页查询SQL模板
于 2022-03-14 13:38:16 首次发布