Is there a way to do list aggregation in ANSI SQL? I am aware that some of the RDBMS provide in-built functions like listagg() in Oracle etc. I tried to look for the ANSI standard document but looks like we have to purchase it (would have been nice if this was available for free as a reference). Thanks.
AFAIK, NO, those are RDBMS specific implementation as you have already noted down (or) GROUP_CONCAT() in case of MySQL. Moreover, ANSI SQL is a standard and not a product by itself.