数据仓库服务 GaussDB(DWS)-字符串函数（Oracle）:STRAGG

时间：2025-02-12 15:04:59

STRAGG

STRAGG是一个字符串聚合函数，用于将多个行的值收集到一个用逗号分隔的字符串中。

输入：STRAGG

  
     SELECT DEPTNO,ENAME,STRAGG(ename) over (partition by deptno order by           ename RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)                 AS ENAME_STR FROM EMP;

输出

  
     SELECT DEPTNO,ENAME,STRING_AGG (    ename,',') over( partition BY deptno ORDER BY  ename RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED  FOLLOWING ) AS ENAME_STR    FROM EMP;