More than 5 years have passed since last update.

Mysqlのgroup_concatをPrestoとRedshiftで書く

Posted at 2016-07-28

Mysqlのgroup_concatをPrestoとRedshiftで書く際に毎回混乱するのでメモ

Mysql

select 
  a,
  group_concat(b separator ',')
from table
group by a

select 
  a,
  array_join(array_agg(b), ',')
from table
group by a

select 
  a,
  listagg(b, ',')
from table
group by a