sqlserver row_number() 分组序号
原表:
OrganizationID | itemprice |
---|---|
XX | A |
XX | B |
XX | C |
YY | A |
YY | B |
YY | C |
XY | A |
XY | B |
结果:
rownum | OrganizationID | itemprice |
---|---|---|
1 | XX | A |
2 | XX | B |
3 | XX | C |
1 | YY | A |
2 | YY | B |
3 | YY | C |
1 | XY | A |
2 | XY | B |
select row_number() over(partition by OrganizationID order by itemprice) rownum,* from Master_margin
本文来自博客园,作者:꧁༺星星的轨迹方程式༻꧂,转载请注明原文链接:https://www.cnblogs.com/SuSVIP/p/17445120.html