HASH_AGG seems like a good option too, since it's an aggregate function that can be used with window functions. But I'm pretty sure LISTAGG is the right answer.
I think LISTAGG is the correct answer here. It's a function that allows you to concatenate multiple rows into a single string, which is a common use case for windowing.
Lauran
13 hours agoGerald
6 days agoBettina
23 days agoPamela
24 days agoVirgilio
5 days agoTijuana
24 days agoCarlota
1 months ago