field1 field2
A 1
A 2
A 3
用一条sql语句查询成:
field1 all
A 1,2,3,
答案:
select field1, wmsys.wm_concat(field2) all from t group by field1
field1 field2
A 1
A 2
A 3
用一条sql语句查询成:
field1 all
A 1,2,3,
答案:
select field1, wmsys.wm_concat(field2) all from t group by field1