<!-- 查询账户注册userId所属账户在数据库(按注册时间排序前20000)序号值,不在则返回null,否则返回序号值 -->
<select id="queryAccountOrderByUserId" parameterType="com.test.bo.CouponIssueRecordBO" resultType="java.lang.Integer">
SELECT
IF(rowno>=COUNT(1),rowno,COUNT(1)) AS rowno
FROM
(
SELECT
a.user_id,
(@rowno :=@rowno + 1) AS rowno
FROM
driver a,
(SELECT(@rowno := 0)) b,
sys_user c
WHERE a.user_id=c.user_id
ORDER BY c.create_time ASC
LIMIT #{provideNum,jdbcType=INTEGER}
) d
WHERE d.user_id = #{userId,jdbcType=BIGINT}
</select>
mysql按用户注册时间排序,输出用户id在数据库中的排序号(用于查找用户是否在优惠名单中)
最新推荐文章于 2022-04-07 09:47:52 发布