1、MySQL 5.7及之前版本

    SELECT A.要显示的字段名称,@FIRST_VALUE := A.分组字段名称,@last :=IF(@FIRST_VALUE = A.分组字段名称, @last + 1, 1 ) AS rn,FROM 表1 A,(SELECT @last := 0, @FIRST_VALUE := NULL ) BORDER BY A.排序字段例：SELECT A.DLR_CODE,A.VAILD_CARD_NO,A.LAST_UPDATED_DATE,@FIRST_VALUE := A.VAILD_CARD_NO ,@last :=IF(@FIRST_VALUE = A.VAILD_CARD_NO, @last + 1, 1 ) AS rn,FROM TB_DLR A,(SELECT @last := 0, @FIRST_VALUE := NULL ) BORDER BY A.VAILD_CARD_NO ,A.LAST_UPDATED_DATE DESC

2、MySQL 8以上版本

select row_number()over(partition by 分组字段 order by 排序字段) from 表名;