SyntaxFix
Write A Post
Hire A Developer
Questions
You can use array_agg function for that:
array_agg
SELECT "Movie", array_to_string(array_agg(distinct "Actor"),',') AS Actor FROM Table1 GROUP BY "Movie";
Result:
See this SQLFiddle
For more See 9.18. Aggregate Functions