Advertisement
ryanarnold

hv_labgen_acc_costed_codes_v dll

Jul 12th, 2019
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.28 KB | None | 0 0
  1.   CREATE OR REPLACE EDITIONABLE VIEW "HV_LABGEN_ACC_COSTED_CODES_V" ("SOURCE_CLINIC", "ACCESSION", "COSTED_CODES") AS
  2.   SELECT source_clinic, accession, LISTAGG(CODE,', ')
  3. WITHIN GROUP (ORDER BY CODE) AS costed_codes
  4. FROM hv_labgen_acc_cost_details
  5. GROUP BY source_clinic, accession;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement