分组之后再排序

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