1.Oracle的分页SQL 例子: 使用了Java下iBatis2框架 SELECT * FROM (SELECT originTable.*, ROWNUM rn FROM ( SELECT * FROM area WHERE id=#id# AND name=#name# ORDER BY $limit.sort.property$ $limit.sort.sortOrder$ ) originTable ) WHERE rn BETWEEN #limit.rowStart#+1 AND #limit.rowEnd# 2.Microsoft SQL Server 例子,使用了Java下iBatis2框架: <select id="getMapUnitListLimit" parameterClass="mapunitform" resultClass="mapunit"> SELECT TOP $limit.currentRowsDisplayed$ * FROM( SELECT TOP $limit.rowEnd$ * FROM mapunit <dynamic prepend="WHERE"> <isNotEmpty prepend="and" property="mapid"> mapid=#mapid# </isNotEmpty> <isNotEmpty prepend=