oracle mybatis 排序 分页

 <select id="queryFarmerInfoListByListId" resultMap="FarmerInfoResultMap">
        select * from(select rownum r,
        id_aims_list_info,
        id_aims_framer_info,
        bank_account_no,
        bank_name,
        address,
        identity_card_no,
        BANK_PHONE,
        IS_COLLECT_FACE,
        IS_COLLECT_VOICE,
        frame_name
        from(
        select* from AIMS_FRAMER_INFO
        where id_aims_list_info = #{listInfoId,jdbcType=VARCHAR}
        and create_by = #{userId,jdbcType=VARCHAR}
        <if test="farmerName !='' and farmerName !=null">
            and frame_name like concat(concat('%',#{farmerName,jdbcType=VARCHAR}),'%')
        </if>
        ORDER BY date_updated DESC))
        where r &gt;= #{start} and r&lt;= #{end}
    </select>