aggregate_distinct.sql 165 B

123
  1. --!syntax_pg
  2. select string_agg(distinct x,y) from (values ('a',','),('b',':'),('a',',')) a(x,y);
  3. select count(distinct x) from (values (1),(2),(1),(3),(2),(1)) a(x);