表名:a
字段1 字段2
1 a
2 a
3 a
4 b
5 b
7 c
8 c
select 字段1=row_number()over(partition by 字段2 order by getdate()),字段2
from a
得到
字段1 字段2
1 a
2 a
3 a
1 b
2 b
3 b
1 c
2 c