Aggregate. Returns a value based on an arbitrary member in a group of values.
any ( expression )
expression |
An expression that will typically reference one or more columns in the input stream. It will be evaluated using an arbitrary member of the group. |
Returns the value for the expression based on an arbitrary member of the group unless the group has no members in which case a NULL value is returned. The function takes any datatype as its argument, and the function returns that same datatype.