## Purpose
Group function which concatenates all individual values, separated by the separator when provided and comma plus space otherwise.
## Syntax
```mermaid
%%{init: {
'theme': 'base',
'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' },
'themeVariables': {
'fontSize': '11px',
'fontFamily': 'Arial'
}
}}%%
flowchart TD
listAggAggregateFunction_start((START))
listAggAggregateFunction_start --> listAggAggregateFunction_0_0[LISTAGG]:::quoted
listAggAggregateFunction_0_0 --> listAggAggregateFunction_0_1["("]:::quoted
listAggAggregateFunction_0_1 --> listAggAggregateFunction_0_2["distinct"]
listAggAggregateFunction_0_2 --> listAggAggregateFunction_0_3[<a href="Invantive UniversalSQL/Grammar/Query Statement/Select Statement#expressionList" class="internal-link">expressionList</a>]
listAggAggregateFunction_0_3 --> listAggAggregateFunction_0_4[")"]:::quoted
listAggAggregateFunction_0_4 --> listAggAggregateFunction_0_5[WITHIN]:::quoted
listAggAggregateFunction_0_5 --> listAggAggregateFunction_0_6[GROUP]:::quoted
listAggAggregateFunction_0_6 --> listAggAggregateFunction_0_7["("]:::quoted
listAggAggregateFunction_0_7 --> listAggAggregateFunction_0_8[<a href="Invantive UniversalSQL/Grammar/Query Statement/Select Statement#orderBy" class="internal-link">orderBy</a>]
listAggAggregateFunction_0_8 --> listAggAggregateFunction_0_9[")"]:::quoted
listAggAggregateFunction_0_9 --> listAggAggregateFunction_end((END))
```