之前公司参考例子:
select distinct qd.htbh,
TO_CHAR(WM_CONCAT(dsr.dsrmc) OVER(PARTITION BY qd.HTBH))
from hz_clfht.tpe_zrhtqd qd, hz_clfht.tpe_dsr dsr
where dsr.htid = qd.id
and dsr.dsrlb = 4
and qd.htbasj > date '2020-04-10';
其他参考地址:
https://www.cnblogs.com/wangfeihu/p/5635434.html
https://www.cnblogs.com/yujin595/p/9829821.html