求一条SQL语句

2013-06-22 01:32:02 246 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

STorM BGC V1.31硬件+SimpleBGC固件：从零搭建三轴云台开发环境（Keil+JLink避坑指南）本文详细介绍了如何从零搭建STorM BGC V1.31硬件+SimpleBGC固件的三轴云台开发环境，涵盖硬件连接、Keil+JLink开发工具配置、固件编译与烧录等关键步骤，并提供了常见问题的解决方案和调试技巧，帮助开发者快速上手三轴云台开发。阅读详情

TB1
dah fid
A 10
A 11
A 12
B 20
B 21
B 22
C 30
C 31
要出来的效果是
dah fid
A 10,11,12
B 20,21,22
C 30,31

...全文

UVM(5)-TLM通信 TLM是一种基于事务 (transaction) 的通信方式，通常在高抽象级语言例如SystemC或者SV/UVM中作为模块之间的通讯方式。阅读详情

linjie0000

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

菲飞斐妃 2013-06-27

打赏
举报

好友难度，厉害啊

习惯性蹭分 2013-06-27

打赏
举报


declare @tab table(id varchar(10),val int)
insert into @tab
select 'A',       10 union
select 'A' ,     11 union 
select 'A'  ,     12 union
select 'B'  ,     20 union
select 'B'  ,     21 union
select 'B' ,      22 union
select 'C'   ,    30 union
select 'C'  ,     31
select id,val=stuff((select ','+cast(val as varchar) from @tab where id=t.id for xml path('')),1,1,'')
 from @tab t group by id

sqlkxr 2013-06-27

打赏
举报


select a.dah,STUFF((select ','+CONVERT(varchar(10),fid) from tb1 where dah=a.dah for xml path('')) ,1,1,'')
from tb1 a group by a.dah

sqlkxr 2013-06-27

打赏
举报


create table tb1(dah varchar(10),fid int)

insert into tb1 select 'A',10
union all
select 'A',11
union all
select 'A',12
union all
select 'B',20
union all
select 'B',21
union all
select 'B',22
union all
select 'C',30
union all
select 'C',31



create function joinstr (@dah varchar(10)) returns varchar(1000)
as
begin

 declare @sql varchar(100)
 set @sql=''
 select @sql=@sql+','+convert(varchar(10),fid) from tb1  where dah=@dah
 return stuff(@sql,1,1,'')

end


select dah,dbo.joinstr(dah) fid from tb1  group by dah

---涛声依旧--- 2013-06-22

打赏
举报

WITH CTE AS (SELECT 'A' dah,10 fid UNION SELECT 'A',11 UNION SELECT 'A',12 UNION SELECT 'B',20 UNION SELECT 'B',21 UNION SELECT 'B',22 UNION SELECT 'C',30 UNION SELECT 'C',31 ) SELECT dah,fid=STUFF((SELECT ','+CAST(fid AS VARCHAR(10)) FROM CTE WHERE dah=t.dah FOR XML PATH('')),1,1,'') FROM CTE t GROUP BY t.dah

---涛声依旧--- 2013-06-22

打赏
举报

CREATE TABLE tb(dah VARCHAR(10),fid int) INSERT tb SELECT 'A' dah,10 fid UNION SELECT 'A',11 UNION SELECT 'A',12 UNION SELECT 'B',20 UNION SELECT 'B',21 UNION SELECT 'B',22 UNION SELECT 'C',30 UNION SELECT 'C',31 SELECT dah,fid=STUFF((SELECT ','+CAST(fid AS VARCHAR(10)) FROM tb WHERE dah=t.dah FOR XML PATH('')),1,1,'') FROM TB t GROUP BY dah

求一条SQL语句

相关推荐