Difference between revisions of "SQL - Group several lines in the same column with LIST TAG"

From GUILLARD WIKI
Jump to navigation Jump to search
(Created page with "<syntaxhighlight lang="sql"> select ost_pid_facility, listagg( ('COL: '||trim(mic_txt_mis_value)||' OST: '||trim(ost_nme_alias)) , ', ' ) WITHIN GROUP (ORDER BY ost_pid_f...")
(No difference)

Revision as of 16:33, 3 May 2018

select ost_pid_facility,
listagg(
  ('COL: '||trim(mic_txt_mis_value)||' OST: '||trim(ost_nme_alias)) ,
  ', '
)
WITHIN GROUP (ORDER BY ost_pid_facility DESC) "COL OST"
from vls_mis_code
inner join vls_fam_global1 on gb1_cde_code = mic_cde_mis_type
inner join vls_outstanding on ost_rid_outstandng = mic_pid_product_id
where mic_cde_mis_type = 'NGCOL' and mic_cde_prod_type = 'LOAN'
group by ost_pid_facility