dlog:SQLServer 2005 ã§group_concat - livedoor Blog（ブãƒã‚°ï¼‰ã‚°ãƒ«ãƒ¼ãƒ—内ã®å€¤ã‚’連çµã—ãŸçµæžœã®æ–‡å—列を返ã™ä¾¿åˆ©é–¢æ•° GROUP_CONCAT()ã‚’SQLServerã§å®Ÿç¾ã™ã‚‹æ–¹æ³• サンプルテーブル：classTable class name 1組 鈴木 1組 ä½è—¤ 2組 ç”°ä¸ ã‚¯ã‚¨ãƒª SELECT classTable.class ,( SELECT c.name + ',' --列åã‚’ã¤ã‘ãªã„ FROM classTable AS c WHERE c.class = classTable.class FOR XML PATH('') ) AS name_concat FROM classTable GROUP BY class çµæžœã‚»ãƒƒãƒˆ class name_concat 1組 鈴木,ä½è—¤, 2組 ç”°ä¸ ãƒã‚¤ãƒ³ãƒˆã¯åˆ—åを付ã‘ãªã„ã“㨠ã‚ã¨ã€æœ€å¾Œã«ã€Œ,ã€ãŒä»˜ã„ã¡ã‚ƒã†ã®ã¯ä»•æ–¹ãªã„
{{#tags}}- {{label}}
{{/tags}}