SQL - Group several lines in the same column with LIST TAG

From GUILLARD WIKI
Revision as of 16:45, 3 May 2018 by Guillard (talk | contribs)
Jump to navigation Jump to search
SELECT country, 
LISTAGG(first_name, ', ') WITHIN GROUP (order by first_name) 
FROM tablename 
GROUP BY country