oracle将多条数据合并成一条

select  t.col1,t.col2  ,wmsys.wm_concat(t.col3||' ') AS col3 , 
wmsys.wm_concat(t.col4||'') as col4,wmsys.wm_concat(t.col5||'') as col5,wmsys.wm_concat(t.col6||'') as col6 
from tablename t GROUP BY  t.col1,t.col2 ;

posted @ 2014-12-15 15:08  Aaron li  阅读(2442)  评论(0编辑  收藏  举报