Deleting `limit 1` cause any problems ? 
<select id="findByAppKey" parameterType="java.lang.String" 
resultMap="BaseResultMap"&gt;
    select
    <include refid="Base_Column_List"/&gt;
    from app_auth
    where app_key = #{appKey,jdbcType=VARCHAR}
    limit 1
</select&gt;<select id="findByAuthIdAndAppName"  resultMap="BaseResultMap"&gt;
    select
    <include refid="Base_Column_List"/&gt;
    from auth_param
    where auth_id = #{authId,jdbcType=VARCHAR}
    and app_name = #{appName,jdbcType=VARCHAR}
    limit 1
</select&gt;
If not Delete , in oracle i will use `rownum =1` &nbsp;replace this
like this :    select
    <include refid="Base_Column_List"/&gt;
    from app_auth
    where app_key = #{appKey,jdbcType=VARCHAR}
    and rownum = 11. Deleting `limit 1`2. Use `rownum=1` replace `limit 
1`please help me to choose 1 or 2

Reply via email to