Row aggregation in sqlite

Question

Does anyone know if String Aggregation is possible in sqlite? If I have a column of animals with 5 lines / numbers, how can I combine them so that the output is in the same field as “dog”, “cat”, “rat”, “mouse”, “mouse” as animals

thank

Answer 1

You are looking for something like the following:

select group_concat(animal) from animals;

This will return something like the following:

dog,cat,rat,mice,mouse

If you do not want to use a comma as a separator, you can add your own separator as a second parameter:

select group_concat(animal, '_') from animals;

which will return:

dog_cat_rat_mice_mouse

Answer 2

I think this will be useful:

group_concat(X)
group_concat(X,Y)

group_concat() , X. Y, X. (",") , Y . .