By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH your_table(ID,IDTAB2,DESC1,DESC2,MEX,CODE)
AS
(
SELECT 1,2,'aa','bb',4,'CS' UNION ALL
SELECT 1,2,'aa','bb',4,'NN' UNION ALL
SELECT 2,1,'ab','cc',2,'AF' UNION ALL
SELECT 2,2,'bb','bc',2,'DC' UNION ALL
SELECT 2,2,'bb','bc',2,'KK' UNION ALL
SELECT 2,2,'bb','bc',2,'JD'
)
SELECT ID,IDTAB2,DESC1,DESC2,MEX,
STRING_AGG ( CODE, ' ' )
FROM your_table
GROUP BY ID,IDTAB2,DESC1,DESC2,MEX
| ID | IDTAB2 | DESC1 | DESC2 | MEX | (No column name) |
|---|---|---|---|---|---|
| 1 | 2 | aa | bb | 4 | NN CS |
| 2 | 1 | ab | cc | 2 | AF |
| 2 | 2 | bb | bc | 2 | KK JD DC |