Aggregate. Returns the most recent non-NULL value in a group of values.
recent ( 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. |
The function returns the same datatype used in the expression.
The recent function could be used to asses profiles on a real time basis to analyze the most current updates and changes.