Skip to content

Instantly share code, notes, and snippets.

@Sapphiron532

Sapphiron532/LISTAGG example.sql

Last active September 19, 2016 13:02
Show Gist options
  • Save Sapphiron532/06dfb3bd816f67ca4236588842e04dc9 to your computer and use it in GitHub Desktop.
Save Sapphiron532/06dfb3bd816f67ca4236588842e04dc9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
LISTAGG example.sql
SELECT drar.PROPERTY_NAME as PROPERTY_NAME,
LISTAGG(dfpr.FORM_ID, ',') WITHIN GROUP (ORDER BY dfpr.FORM_ID) as FORM_ID
FROM DICT_RESERVED_ACCOUNT_R drar JOIN
DICT_FORM_PROPS_RATIO dfpr
ON dfpr.PROPERTY_NAME= drar.PROPERTY_NAME
WHERE drar.PROPERTY_NAME = 'title'
GROUP BY drar.PROPERTY_NAME
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment