1.字段为竖向显示的时候
在这里我们合并 sqr ,将id为(47,50,51)合并
SELECT
name = (
(
stuff(
(
SELECT
',' + CAST (a.sqr AS VARCHAR)
FROM
formtable_main_11 a
WHERE
a.id in (47,50,51)
ORDER BY
a.id FOR xml path ('')
),
1, 1, ''
)
)
)
显示结果:
2.字段为横向显示的时候合并
在这里我们合并(requestId,sqr,sqbm)id为47时
select concat(requestId,',',sqr,',',sqbm) as ss
from formtable_main_11
where id =47
显示结果: