JSON_ARRAYAGG(expr)
JSON_ARRAYAGG(expr)
Combines column values within a group into a single JSON array of those values.See examples.
JSON_ARRAYAGG_DISTINCT(expr)
JSON_ARRAYAGG_DISTINCT(expr)
Combines column values within a group into a single JSON array of those values,
removing any duplicates.See examples.
JSON_COLLECT_SET(expr)
JSON_COLLECT_SET(expr)
Alias for
JSON_ARRAYAGG_DISTINCT.