Re: Delete limit

[XiaoYu]

Ok,

rom1c77 <280385...@qq.com.invalid> 于2021年9月22日周三 下午4:44写道：

> Deleting&nbsp;`limit 1`&nbsp;cause any problems&nbsp;?&nbsp;
> <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