set @rank=0,@c=null;
select a.id,a.cd,
@rank := if(@c = name,@rank+1,1) rank,
@c := name
from cs order by a.name,a.cd;
mysql分组排序
最新推荐文章于 2024-10-08 11:31:33 发布
set @rank=0,@c=null;
select a.id,a.cd,
@rank := if(@c = name,@rank+1,1) rank,
@c := name
from cs order by a.name,a.cd;