SQLite: group by

group_concat

group_concat: concatenates values within a group. It is SQLite's implementation of the SQL standard feature T625 (listagg).

create table foo (
  grp    text,
  val    text
);

insert into foo values ('A', 'abc');
insert into foo values ('A', 'de');
insert into foo values ('A', 'fghij');

insert into foo values ('B', 'one');
insert into foo values ('B', 'two');

insert into foo values ('C', 'foo');
insert into foo values ('C', 'bar');
insert into foo values ('C', 'baz');

select
  grp,
  group_concat(val)
from
  foo
group by
  grp;
--
--A|abc,de,fghij
--B|one,two
--C|foo,bar,baz

Github repository about-sqlite, path: /sql/select/group_by/group_concat.sql

SQLite: group by

group_concat

See also