17,140
社区成员




SQL> SELECT * FROM test1;
ID F1 F2
-- ---------- ----------
1 直辖市 北京市
1 直辖市 上海市
3 其他省市 河北省
SQL>
SQL> SELECT f1,max(sys_connect_by_path(f2, '/'))
2 FROM (SELECT f1,f2, row_number() over(PARTITION BY f1 ORDER BY f2) rn FROM test1) t
3 START WITH rn = 1
4 CONNECT BY rn = PRIOR rn +1 AND f1= PRIOR f1
5 GROUP BY f1;
F1 MAX(SYS_CONNECT_BY_PATH(F2,'/'
---------- --------------------------------------------------------------------------------
其他省市 /河北省
直辖市 /北京市/上海市
SQL>
SQL> select p_type,wmsys.wm_concat(p_name) from province group by p_type;
P_TYPE WMSYS.WM_CONCAT(P_NAME)
---------------------------------------- --------------------------------------------------------------------------------
直辖市 S.N,Y)m%
省市 l_?
SELECT a.gw_id, a.gw_title, a.gw_wenhao_year, wm_concat(b.ownername)
FROM gw_qianbao a, wfmc_templatenode_owner_inst b
WHERE a.gw_id = b.instance_id
GROUP BY a.gw_id, a.gw_title, a.gw_wenhao_year
ORDER BY a.gw_id