Answers for "group concat in postgresql"

SQL
7

postgres concat

update "ExportTables" SET "Name" = CONCAT("Name", '.csv')
Posted by: Guest on February-04-2021
0

How to Group by and concatenate arrays with all columns in PostgreSQL

SELECT DATE_TRUNC('day', date_time), JSON_AGG(t) AS row, SUM(amount) AS total
FROM table_a t GROUP BY DATE_TRUNC('day', date_time);
Posted by: Guest on November-15-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language