listagg(distinct …)

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⊘ 3.5.7 - 3.40.0⊘ 2008R2 - 2022⊘ 8.3 - 15✓ 19c+⊘ 11gR1 - 18c⊘ 5.0 - 8.0.31⊘ 5.1 - 10.10⚠ 11.1 - 11.5.7⊘ 9.7 - 10.5a⊘ 2.0
  1. If ordered by the aggregated values: listagg(distinct X,…) within group (order by X)