How to select all the column values corresponding to duplicate values in different column of a table using flask ORM?

Flask flyf35 — 27 March 2023 · Comments off

Solution

select customer_id, STRING_AGG(mean_value, ',' order by mean_value) means
from mytable group by customer_id order by customer_id;

select concat('{', customer_id, ': ', '[', STRING_AGG(mean_value, ',' order by mean_value), ']}') output
from mytable group by customer_id order by customer_id;