mysql8分组后排序

最新推荐文章于 2024-04-03 17:43:33 发布

原创最新推荐文章于 2024-04-03 17:43:33 发布 · 1.0k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

数据库专栏收录该内容

8 篇文章

订阅专栏

SELECT b.id              uid,
               b.mobile,
               count(1)          openedCount,
               sum(share_amount) shareTotalAmount
        FROM (select *, ROW_NUMBER() OVER (PARTITION BY share_uid ORDER BY create_time desc)
              from ums_share_red_packet) a
                 LEFT JOIN ums_member b ON a.share_uid = b.id
        WHERE a.delete_status = 0
          AND b.`status` = 1
          AND ssp_id = #{settingId}
        GROUP BY a.share_uid
        HAVING openedCount >= #{limitShareCount}
        ORDER BY openedCount DESC,
                 a.create_time ASC