22,207
社区成员
发帖
与我相关
我的任务
分享
declare @Table table (line_ID int,TITLE_ID int,NAME varchar(4),KEY_INDEX int)
insert into @Table
select 1,1,'A',2 union all
select 2,1,'B',4 union all
select 3,2,'C',1
select line_ID,name,row_name=row_number() over(partition by title_id order by key_index)
from @Table
/*
line_ID name row_name
----------- ---- --------------------
1 A 1
2 B 2
3 C 1
declare @line table (id int,title_id int,name varchar(1),key_index int)
insert into @line
select 1,1,'A',2 union all
select 2,1,'B',4 union all
select 3,2,'C',1
select id,name,row_number() over(partition by title_id order by id) as row_name
from @line
/*
id name row_name
----------- ---- --------------------
1 A 1
2 B 2
3 C 1
*/
select *,row_name=row_number() over(partition by title_id order by key_index)
from line
row_number()over(order by key_index) as row_name
select
id,name,row_number() over(partition by title_id order by id) as row_name
from
tb