select distinct no,text from *** 得到 1 A 2 A 2 B 3 B 然后在java里面搞啊,直接在表里面搞难吧
WITH SQL AS ( select 1 as no , 'A' text from dual union all select 1, 'A' from dual union all select 2, 'A' from dual union all select 2, 'B' from dual union all select 3, 'B' from dual ) SELECT NO,wm_concat(DISTINCT text) FROM SQL GROUP BY NO
SELECT no, wmsys.wm_concat(text) as text FROM (select distinct(no, text) from tablename) GROUP BY no
得到
1 A
2 A
2 B
3 B
然后在java里面搞啊,直接在表里面搞难吧
select 1 as no , 'A' text from dual union all
select 1, 'A' from dual union all
select 2, 'A' from dual union all
select 2, 'B' from dual union all
select 3, 'B' from dual )
SELECT NO,wm_concat(DISTINCT text) FROM SQL GROUP BY NO
FROM (select distinct(no, text)
from tablename)
GROUP BY no