create table 原表(A int,B varchar(5))insert into 原表 select 1,'a' union all select 1,'b' union all select 2,'a' union all select 2,'a' union all select 2,'c' select A, B, row_number() over(partition by A order by getdate()) '序号' from 原表/* A B 序号 ----------- ----- ---------- 1 a 1 1 b 2 2 a 1 2 a 2 2 c 3(5 row(s) affected) */
create table 原表(A int,B varchar(5))insert into 原表
select 1,'a' union all
select 1,'b' union all
select 2,'a' union all
select 2,'a' union all
select 2,'c'
select A,
B,
row_number() over(partition by A order by getdate()) '序号'
from 原表/*
A B 序号
----------- ----- ----------
1 a 1
1 b 2
2 a 1
2 a 2
2 c 3(5 row(s) affected)
*/