分组之后再排序

select SizeType,[Description],[USA],[CH],row_number() over( partition by [SizeType], [Description] order by [CH] asc )as Seq
from M_SizeDetail

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/yzenet/p/2695594.html