34,576
社区成员
发帖
与我相关
我的任务
分享
create table tb(id int identity(1,1),v varchar(10))
go
insert into tb
values('a')
go 21
select *,
'group'+ cast((id-1) / 5+1 as varchar) 'group'
from tb
/*
id v group
1 a group1
2 a group1
3 a group1
4 a group1
5 a group1
6 a group2
7 a group2
8 a group2
9 a group2
10 a group2
11 a group3
12 a group3
13 a group3
14 a group3
15 a group3
16 a group4
17 a group4
18 a group4
19 a group4
20 a group4
21 a group5
*/
create table tb(id int identity(1,1),v varchar(10))
go
insert into tb
values('a')
go 21
select *,
'group'+ cast((id-1) / 5 as varchar) 'group'
from tb
/*
id v group
1 a group0
2 a group0
3 a group0
4 a group0
5 a group0
6 a group1
7 a group1
8 a group1
9 a group1
10 a group1
11 a group2
12 a group2
13 a group2
14 a group2
15 a group2
16 a group3
17 a group3
18 a group3
19 a group3
20 a group3
21 a group4
*/