oracle分組統計某列逗號隔開數據，oracle分組逗號隔開

oracle分組統計某列逗號隔開數據，oracle分組逗號隔開

所有版本的oracle都可以使用select wm_concat(name) as name from user; 
但如果是oracle11g，使用select listagg(name, ',') within group( order by name) as name from user;
效率更高，官方也更推薦這種寫法。