Top "String-aggregation" questions

This tag is intended for SQL questions where multiple string (character) values should be aggregated into a single value using GROUP BY.

SQL Server equivalent to GROUP_CONCAT()

I have this database: And I need to get the following data for each Client: Client Name Contract Name(s) …

Read More
sql sql-server join string-aggregation
string aggregation in Oracle 10g

How to aggregate string( concatenate) with Oracle 10g SQL?

Read More
sql string oracle10g string-aggregation
Oracle Function: Replicate wm_concat

I currently am working on a project within Crystal Reports that refuses to use the undocumented function WM_CONCAT, which …

Read More
oracle function oracle10g string-aggregation wm-concat
Convert LISTAGG to XMLAGG Oracle

I have a below SQL and I am trying to convert the LISTAGG to XMLAGG. My DB version is 12.1 and …

Read More
sql oracle listagg string-aggregation
How to avoid duplicates in the STRING_AGG function

My query is below: select u.Id, STRING_AGG(sf.Naziv, ', ') as 'Ustrojstvena jedinica', ISNULL(CONVERT(varchar(200), (STRING_…

Read More
tsql ssms distinct string-aggregation