Some print.
Some print.
~SingleForum~无废话记录~ + ~19~记录点有用的好吗?少说废话少装b~

~SingleForum~无废话记录~ » other

ORACLE多行合并

Started 2 years ago by admin. | Tags: .

例如有如下数据:m_researcher_stock_rel表

N_SEC_CODE C_RESEARCHER_CODE

000297 chenpeng

000297 liusu

合并处理后需显示为:

000297 chenpeng,liusu

wmsys.wm_concat 的用法

select N_SEC_CODE, wmsys.wm_concat(C_RESEARCHER_CODE) p from m_researcher_stock_rel GROUP BY N_SEC_CODE

RSS feed for this topic