- SELECT
- id,
- [name] = stuff(
- (
- SELECT
- ',' + [name]
- FROM
- tabla AS a
- WHERE
- a.name = b.namefor xml path ('')
- ),
- 1,
- 1,
- ''
- ),
- [sex] = stuff(
- (
- SELECT
- ',' + [sex]
- FROM
- tabla AS a
- WHERE
- a.id = b.id FOR xml path ('')
- ),
- 1,
- 1,
- ''
- )
- FROM
- tabla AS b
- GROUP BY
- id
来源: http://www.bubuko.com/infodetail-3520220.html