LISTAGG使用 

SELECT LISTAGG(fun_getaaa103('AAE140', a.aae140), ',') WITHIN GROUP(ORDER BY a.aae140) AS aae140str
  FROM ac02 a
 where a.aac001 = '10002070436';

SELECT * FROM ac02 a where a.aac001 = '10002070436';

 

 

 

查询结果：

 

posted @ 2020-11-16 10:24  moonsoft  阅读(134)  评论(0)  编辑  收藏  举报