且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Oracle SQL错误:ORA-00923:找不到预期的“来自关键字"

更新时间:2022-04-15 22:41:51

可能与使用代码"的标识符有关

Could be related to the indentifier try using "code"

SELECT CATEGORY,ANTIGENNAME,LATINCOMPOSITION,HYCORCODE,FDACLEARANCE,
    LISTAGG(ORCHARDCODE, ';')
     WITHIN GROUP (ORDER BY ORCHARDCODE) as "code"
 from tablename
 group by HYCORCODE