반응형
Table TEST
|
ID |
VALUE |
|
1 |
a |
|
1 |
b |
|
1 |
c |
|
2 |
d |
|
2 |
e |
|
2 |
f |
SELECT ID, WM_CONCAT(VALUE)
FROM TEST
GROUP BY ID
RESULT
|
ID |
WM_CONCAT(VALUE) |
|
1 |
a,b,c |
|
2 |
d,e,f |
삽질하기/SQL
Table TEST
|
ID |
VALUE |
|
1 |
a |
|
1 |
b |
|
1 |
c |
|
2 |
d |
|
2 |
e |
|
2 |
f |
SELECT ID, WM_CONCAT(VALUE)
FROM TEST
GROUP BY ID
RESULT
|
ID |
WM_CONCAT(VALUE) |
|
1 |
a,b,c |
|
2 |
d,e,f |