qq_40138785的博客

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

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