mysql中根据一个字段相同记录写递增序号,如序号结果,如何实现?
mysql中根据一个字段相同记录写递增序号,如序号结果,如何实现?
mysql中实现方式如下:
select merchantId, NameCn, send_date, deliver_name, deliver_address, contact, bill_status, bill_code, rank from (select heyf_tmp.merchantId, heyf_tmp.NameCn, heyf_tmp.send_date, heyf_tmp.deliver_name, heyf_tmp.deliver_address, heyf_tmp.contact, heyf_tmp.bill_status, heyf_tmp.bill_code, @rownum:=@rownum + 1, if(@pdept = heyf_tmp.contact, @rank:=@rank + 1, @rank:=1) as rank, @pdept:=heyf_tmp.contact from (select t1.merchantId, t2.NameCn, t1.send_date, t1.deliver_name, t1.deliver_address, concat(t1.deliver_phone,',',t1.deliver_mobile) as 'contact', t1.bill_status, t1.bill_code from bill_master t1 left join sys_merchant_master t2 on t1.merchantId = t2.merchantId where bill_status != 10 order by deliver_phone,deliver_mobile) heyf_tmp, (select @rownum:=0, @pdept:=null, @rank:=0) a) result;
实现结果截图:
码农小明
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步