listagg WITHIN GROUP 不能执行

select department_id,listagg(department_name, ',') WITHIN GROUP(ORDER BY department_name) department_name from T_WX_CORP_DEPARTMENT  group by department_id;

DB2数据库10.1

执行该语句时,报错:Lookup Error - DB2 Database Error: ERROR [42601] [IBM][DB2/NT64] SQL0104N  An unexpected token "department_id,listagg(department_name, ',') WITHIN" was found following "select ".  Expected tokens may include:  "".

参与1

0同行回答

“答”则兼济天下,请您为题主分忧!

提问者

gejian_java
其它中软

问题来自

问题状态

  • 发布时间:2017-05-16
  • 关注会员:1 人
  • 问题浏览:4765
  • X社区推广