qq_40138785的博客

with temp as( select 'China' nation ,'Guangzhou' city from dual union all select 'China' nation ,'Shanghai' city from dual union all select 'China' nation ,'Beijing' city from dual union all select '...

一：SELECT DISTINCT        TYPE,        SUBTYPE,        LISTAGG (EN, ' | ')           WITHIN GROUP (ORDER BY EN)           OVER (PARTITION BY TYPE, SUBTYPE)           AS SKILLS   FROM (SELECT DIS...