ListDistinctTuple.sql 140 B

123456789
  1. /* syntax version 1 */
  2. USE plato;
  3. SELECT
  4. key,
  5. AGGREGATE_LIST_DISTINCT(AsTuple(subkey, value))
  6. FROM Input
  7. GROUP BY key
  8. ORDER BY key