<select id="selectForList" resultMap="userResult" parameterClass="java.util.Map">
        select p.* from (select t.*,rownum from UTAA_USER t
        <isParameterPresent>
            <include refid="User-Where" />
            <isPropertyAvailable property="ABATOR_ORDER_BY_CLAUSE">
                order by $ABATOR_ORDER_BY_CLAUSE$
            </isPropertyAvailable>        
        ) p where 1=1
            <isPropertyAvailable property="rowStartNum">
                    and p.rownum >= $rowStartNum$
            </isPropertyAvailable>
            <isPropertyAvailable property="rowEndNum">
                    <![CDATA[and p.rownum <= $rowEndNum$]]>
            </isPropertyAvailable>
        </isParameterPresent>
        <isNotParameterPresent>
        ) p
        </isNotParameterPresent>    
    </select>