...
As a single-set aggregate function, LISTAGG operates on all rows and returns a single output row. For example, you want to may show student group in one single row with multiple values. Reference in CUNYfirst query: tabcu_sr_00045_2
...
Panel |
---|
LISTAGG(CASE WHEN M.STDNT_GROUP IN ('SEEK') THEN 'SEEK' WHEN M.STDNT_GROUP IN ('PATH') THEN 'PATH' WHEN M.STDNT_GROUP IN ('HPNS', 'HREG', 'PROV', 'BSCH', 'DSCH') THEN 'HONORS' ELSE 'NULL' END, ', ') WITHIN GROUP (ORDER BY CASE WHEN M.STDNT_GROUP IN ('SEEK') THEN 'SEEK' WHEN M.STDNT_GROUP IN ('PATH') THEN 'PATH' WHEN M.STDNT_GROUP IN ('HPNS', 'HREG', 'PROV', 'BSCH', 'DSCH') THEN 'HONORS' ELSE 'NULL' END) |
Ethnicity:
User can use this as a CF field
Panel |
---|
LISTAGG(CASE WHEN P.ETHNIC_GROUP IN ('1') THEN 'WHITE' |