distinct_groupby.sql 142 B

123456
  1. /* syntax version 1 */
  2. use plato;
  3. select distinct k || "_" as k1, "_" || v as v1 from Input2 group by key as k, value as v order by k1,v1;