Name
DB.DBA.BAG_OF_NONNULLS_AGG — Returns a vector of passed values ingoring NULL arguments.
Synopsis
vector DB.DBA.BAG_OF_NONNULLS_AGG ( |
value_expression any
) ; |
Description
DB.DBA.BAG_OF_NONNULLS_AGG
returns
a vector of passed values. Similar to DB.DBA.VECTOR_OF_NONNULLS_AGG()
but ignores NULL arguments.
The order of items in the vector is not predefined and may vary from run to run.
Parameters
value_expression
Value of item for aggregation.
Return Types
Any
Examples
Example24.7.Simple Use
SELECT DB.DBA.BAG_OF_NONNULLS_AGG (subquery.X) FROM (SELECT X FROM ... ORDER BY X) as subquery
SELECT DB.DBA.BAG_OF_NONNULLS_AGG (subquery.Y) FROM (SELECT Y FROM ... ORDER BY X) as subquery