--> 数据库版本:
--> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22
--> 测试数据:[TB]
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TB]')
AND type in (N'U'))
DROP TABLE [TB]
GO
---->建表
create table [TB]([字段1] varchar(1),[字段2] varchar(1))
insert [TB]
select 'a','c' union all
select 'b','c'
GO
SELECT
字段1 =stuff((
select '+'',''+'+convert(varchar(20),字段1) FROM [TB] WHERE 字段2 = a.字段2 for xml path(''))
,1,5,''),a.字段2
FROM [TB] a
group by a.字段2
--> 查询结果
SELECT * FROM [TB]
--> 删除表格
--DROP TABLE [TB]
字段遍历累加
最新推荐文章于 2022-12-28 09:25:01 发布