Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE EDITIONABLE VIEW "HV_LABGEN_ACC_COSTED_CODES_V" ("SOURCE_CLINIC", "ACCESSION", "COSTED_CODES") AS
- SELECT source_clinic, accession, LISTAGG(CODE,', ')
- WITHIN GROUP (ORDER BY CODE) AS costed_codes
- FROM hv_labgen_acc_cost_details
- GROUP BY source_clinic, accession;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement