1.rank到相同的是同一级,下一级进行跳级
select
@rownum:=@rownum+1 as rownum,
if(@shuliang=shuliang,@rank,@rank:=@rownum) as rank,
@shuliaing:=shuliang

2.rank相同是同一级,下一级不跳级

参考:
1.rank到相同的是同一级,下一级进行跳级
select
@rownum:=@rownum+1 as rownum,
if(@shuliang=shuliang,@rank,@rank:=@rownum) as rank,
@shuliaing:=shuliang

2.rank相同是同一级,下一级不跳级

参考:

被折叠的 条评论
为什么被折叠?