Question

oracle sql的model语句错与提示重复的列名

select empno,ename,mgr,deptno
from emp
model return updated rows
partition by(deptno,job)
dimension by (deptno,empno)
measures(mgr)
rules(
mgr[deptno in(10,20),empno]=5000
)这是我写的oracle的sql语句但是提示是第 1 行出现错误:
ORA-00957: 重复的列名，这是怎么回事儿呢

Answer 1

select C_HTBH, replace(wmsys.wm_concat(C_YSRQ),',',';') from table group by C_HTBH;