SQL - Group several lines in the same column with LIST TAG
Jump to navigation
Jump to search
SELECT country,
LISTAGG(first_name, ', ') WITHIN GROUP (order by first_name)
FROM tablename
GROUP BY country