Oracle分页

方式一：

select k.* from (
	select d.*,ROWNUM as rn from ZHYY_FISH_DIE d  where rownum <= 10
) k where rn  >=3

SELECT K.* FROM (
	SELECT P.*, ROWNUM AS RN FROM (
			SELECT DISTINCT MCM.CONFIG FROM MT_CONFIG_MATERIAL MCM
	) P WHERE ROWNUM <= #{end, jdbcType=INTEGER}
) K WHERE RN > #{start, jdbcType=INTEGER}

方式二：

  SELECT * FROM (
      SELECT	ML.CN_NAME AS CN_NAME,
        <if test="qo != null and qo.orderBySql != null and qo.orderBySql != '' ">
            ROW_NUMBER() OVER( ORDER BY ${qo.orderBySql} ) RN,
        </if>
                FROM  MT_LANG ML 
        ]]>
        <include refid="queryCondition" />
        
   ) P
   WHERE P.RN > #{start, jdbcType=INTEGER}
     AND P.RN <= #{end, jdbcType=INTEGER}
     

QS：这样查不出结果

select d.* from ZHYY_FISH_DIE d  where rownum between 3 and 10

select rownum,id,name from loaddata where rownum > 2 and rownum <10