This tag is intended for SQL questions where multiple string (character) values should be aggregated into a single value using GROUP BY.
I have a simple query: select * from countries with the following results: country_name ------------ Albania Andorra Antigua ..... I would …
sql oracle concatenation pivot string-aggregationWould it be possible to construct SQL to concatenate column values from multiple rows? The following is an example: Table …
sql oracle string-aggregationI am looking for a way to concatenate the strings of a field within a group by query. So for …
sql postgresql group-by string-aggregationHow can I achieve the following in oracle without creating a stored procedure? Data Set: question_id element_id 1 7 1 8 2 9 3 10 3 11 3 12 Desired …
sql oracle concatenation string-aggregationI know that in sql server we cannot use Group_concat function but here is one issue i have in …
sql-server string-aggregation sql-server-group-concatI'm trying to migrate a MySQL-based app over to Microsoft SQL Server 2005 (not by choice, but that's life). In the …
sql sql-server sql-server-2005 string-aggregationI have 3 tables called: Applications (id, name) Resources (id, name) ApplicationsResources (id, app_id, resource_id) I want to show …
sql sql-server tsql string-aggregationI have a table and I'd like to pull one row per id with field values concatenated. In my table, …
sql postgresql group-concat string-aggregationI have a table: CREATE TABLE tblproducts ( productid integer, product character varying(20) ) With the rows: INSERT INTO tblproducts(productid, product) …
sql postgresql string-aggregationI have to replace the Oracle driver with the newest PostgreSQL. PostgreSQL doesn't know the function LISTAGG. I have to …
sql postgresql string-aggregation listagg