mysql 分组行号查询

最新推荐文章于 2024-08-21 11:02:00 发布

weixin_34406086

最新推荐文章于 2024-08-21 11:02:00 发布

阅读量243

点赞数

文章标签： python 数据库

原文链接：https://my.oschina.net/u/3238650/blog/3023313

版权

2019独角兽企业重金招聘Python工程师标准>>>

SELECT 
    @row_number:=CASE
        WHEN @customer_no = customerNumber THEN @row_number + 1
        ELSE 1
    END AS num,
    @customer_no:=customerNumber as CustomerNumber,
    paymentDate,
    amount
FROM
    payments,(SELECT @customer_no:=0,@row_number:=0) as t
ORDER BY customerNumber;

转载于:https://my.oschina.net/u/3238650/blog/3023313