concatenate

[polankiraghuram]

i have duplicates in job name column,i want to remove duplicates from job name column and want to concatenate reference column based on job name .tell query ?

[diegozecchini]

Hi!
In SQL Server, you can use STRING_AGG

SELECT
job_name,
STRING_AGG(reference, ', ') AS concatenated_references
FROM
your_table
GROUP BY
job_name;

[marksouzacosta]

Hi @polankiraghuram,

Can you please give some examples with screen shots of what are you trying to achieve?

Regards,

Mark Costa

[diegozecchini]

hi @polankiraghuram if you found a solution, please tell us, it is useful to community