oracle mybatis 分页

---
  Integer start = (_pageNo-1)*_pageSize;
  if(start <= 0) {
      start = null;
  }
  Integer end = (_pageNo)*_pageSize;

SELECT
  *
  FROM
  (
    SELECT
    row_.*,
    ROWNUM AS rownum_
    FROM
    (
      普通sql语句
    ) row_
    WHERE
      ROWNUM &lt;= #{endCol}
  )
  <if test="startCol != null">
    WHERE
    rownum_ &gt; #{startCol}
  </if>
</select>