在Oracle表中,有一列为ename,现在的需求,是将不同部门的合计工资显示,并将ename显示在同一行。用+号连接。
SQL> select
2 deptno,
3 sum(sal),
4 listagg(ename,'+') within group(order by empno) as ename
5 from emp
6 group by deptno
7 order by 1,2;
DEPTNO SUM(SAL) ENAME
---------- ---------- ---------------------------------------------
10 8750 CLARK+KING+MILLER
20 10875 SMITH+JONES+SCOTT+ADAMS+FORD
30 9400 ALLEN+WARD+MARTIN+BLAKE+TURNER+JAMES
Elapsed: 00:00:00.00