SELECT
@group_row:=CASE when @parent_code=SUBSTR(a.sdmfid,1,7) then @group_row+1 else 1 end as groupRow,
# case when @v <> sdmfid then @v := sdmfid else @v end AS row_num_v,
@parent_code:=SUBSTR(a.sdmfid,1,7) as parent_code,
SUBSTR(a.sdmfid,1,5),SUBSTR(a.sdmfid,1,7),a.sdmfid,sum(a.sdcjje)
FROM
wx_erp_deptsale a,( select @group_row:=1, @parent_code:='') as b
where s_date like ‘2021/01%’
GROUP BY SUBSTR(sdmfid,1,5),SUBSTR(sdmfid,1,7),sdmfid
ORDER BY SUBSTR(sdmfid,1,5),SUBSTR(sdmfid,1,7),sdmfid,sum(a.sdcjje) desc