用逗號合併多筆資料的某一欄位

這一招還蠻好用的
SELECT n_sec_code, wmsys.wm_concat (c_researcher_code) as result
FROM m_researcher_stock_rel
GROUP BY n_sec_code
引用自:http://www.cnblogs.com/heekui/archive/2009/07/30/1535516.html