分页查询

oracle中分页查询的基本语法：

　　select *from (真正的查询) where rownum<=n;

<select id="getDevCurActInfo" parameterType="java.util.HashMap" resultMap="curActMap">
        select * from 
            (
                select A.*,rownum rn from 
                (
                    select * from bsec_dev_act t where t.dev_id=#{devCurAct.devId,jdbcType=NUMERIC} and t.act_type=#{devCurAct.actType,jdbcType=VARCHAR} 
                    and t.act_time between to_timestamp(#{devCurAct.beginDate,jdbcType=VARCHAR},'yyyy-mm-dd hh24:mi:ss')  and to_timestamp(#{devCurAct.endDate,jdbcType=VARCHAR},'yyyy-mm-dd hh24:mi:ss')
                    order by t.act_id desc 
                ) A
            )where rn between #{pagination.startIndex} and #{pagination.endIndex}
    </select>