Distinct values using string_agg

• jagjitsingh

  Ten Centuries

  Points: 1072

  More actions

  April 16, 2025 at 2:13 pm

  #4579972

  Hi

  Is it possible to get distinct values using string_agg

  Select T1."transType",

  WHEN T1."TransType" = '46' THEN (SELECT STRING_AGG (A0."LocCode", ',') from PCH1 A0 inner join OPCH A1 on A0."DocEntry" = A1."DocEntry" and A1."BPLId" = T1."BPLId" inner join VPM2 A2 on A2."DocNum" = T1."CreatedBy" and A0."DocEntry" = A2."DocEntry")

  from JDT1 T1

  Thanks

• frederico_fonseca

  SSCoach

  Points: 16216

  More actions

  April 16, 2025 at 4:16 pm

  #4580014

  use a "group by" on the string_agg sub query