Oracle的row_number() over partition by 如何改造成MySQL语句

Question

现在业务中有一个Oracle语句

select row_number()
                     over (partition by sr.accnt_currency_type order by sr.accnt_currency_type, sr.partner_carrier_cd, sr.sttl_month, sr.voucher_type desc) rank,
             sr.partner_carrier_cd,
             sr.sttl_month,
             sr.voucher_type,
             sr.doc_out_num,
             sr.doc_out_sdr_value,
             sr.doc_in_num,
             sr.doc_in_sdr_value,
             sr.net_amount_sdr,
             sr.accnt_currency_type,
             sr.exchange_rate,
             sr.actural_pay_amount,
             sr.pay_dt
      from payment_doc_detail pdd,
           sttl_result sr
      where pdd.sttl_rec_no = sr.sttl_rec_no
        and pdd.status = 2;

有大佬可以指导一下如何改造成MySQL支持的语句吗

Answer 1

mysql 分组后加序号：

SET @row_number=0, @customer_no=0;
SELECT
    @row_number:=CASE
        WHEN @customer_no = s.age THEN @row_number + 1 
        ELSE 1
    END AS num,
    @customer_no:=s.age AS stu_age,
    s.id, 
    s.name 
FROM
    student s
ORDER BY
    s.age