# 对应oracle中row_number() over(),即分组排序,在MySQL中的例子:
# 基于mobile_no分组,于分组中基于process_dt排序
SET @rn=0;
SET @last_mobile_no=-1;
SELECT *, IF(@last_mobile_no = mobile_no, @rn := @rn + 1, @rn := 1) AS rn,
@last_mobile_no := mobile_no AS last_mobile_no
FROM cha_zheng_person
where result = '通过'
ORDER BY mobile_no, date_format(process_dt,'%Y-%m-%d') desc
;