LIST function [Aggregate]

LIST( 
[ DISTINCT ] string-expression
[  , delimiter-string ] )

string-expression A string expression, usually a column name. For each row in the group, the value of string-expression is added to the result string, with values separated by delimiter-string. When DISTINCT is specified, only unique string-expression values are added.
delimiter-string A delimiter string for the list items. The default setting is a comma. There is no delimiter if a value of NULL or an empty string is supplied. The delimiter-string must be a constant.

LONG VARCHAR
LONG NVARCHAR

The LIST function returns the concatenation (with delimiters) of all the non-NULL values of X for each row in the group. If there does not exist at least one row in the group with a definite X-value, then LIST( X ) returns the empty string.

NULL values and empty strings are ignored by the LIST function.

A LIST function cannot be used as a window function, but it can be used as input to a window function.

SQL/2008 Vendor extension.

The following statement returns all street addresses from the Employees table.

SELECT LIST( Street ) FROM Employees;

LIST function [Aggregate]

Syntax

Parameters

Returns

Remarks

Standards and compatibility

Examples