SELECT
@group_row:=CASE WHEN @parent_code=a.cpx THEN @group_row+1 ELSE 1 END AS rank,
@parent_code:=a.cpx AS cpx,
a.yf,a.nf,a.khmc,a.rmbje,a.account_period
FROM (SELECT * FROM `fi_result_stat_srtop`
@group_row:=CASE WHEN @parent_code=a.cpx THEN @group_row+1 ELSE 1 END AS rank,
@parent_code:=a.cpx AS cpx,
a.yf,a.nf,a.khmc,a.rmbje,a.account_period
FROM (SELECT * FROM `fi_result_stat_srtop`
WHERE yf = 10 AND account_period='2017-10' ) a ,( SELECT @group_row:=1, @parent_code:='') AS b
以上是根据cpx分组后再排序的结果!