
核心SQL如下:
select
hi_psndoc_work.pk_psndoc,
LISTAGG(hi_psndoc_work.begindate||'至'||hi_psndoc_work.enddate||' '||hi_psndoc_work.workcorp||' '||hi_psndoc_work.workpost,',')
WITHIN GROUP (ORDER BY hi_psndoc_work.begindate desc) as workhistory
from hi_psndoc_work
GROUP BY hi_psndoc_work.pk_psndoc