Wednesday 11 October 2017

Amazon Redshift announces support for LISTAGG DISTINCT

The LISTAGG aggregate function orders the rows for each group in a query according to the ORDER BY expression, then concatenates the values into a single string. With the new DISTINCT argument, you can now eliminate duplicate values from the specified expression before concatenating the values into a single string. For more information, see LISTAGG Function in the Amazon Redshift Database Developer Guide.



from What's New http://ift.tt/2xzBXkY

No comments:

Post a Comment