select row_number() over(partition by CODE order by SEQUENCE) as RowIndex from Table
注：根据表的CODE 字段分组，组内根据SEQUENCE字段排序，生成序号 RowIndex
本文共 183 字，大约阅读时间需要 1 分钟。
select row_number() over(partition by CODE order by SEQUENCE) as RowIndex from Table
注：根据表的CODE 字段分组，组内根据SEQUENCE字段排序，生成序号 RowIndex
转载于:https://www.cnblogs.com/sugarwxx/p/9324388.html