MERGE
MERGEβ
descriptionβ
Syntaxβ
AGGREGATE_FUNCTION_MERGE(agg_state)
The aggregated intermediate results are aggregated and calculated to obtain the actual result.
The type of the result is consistent with AGGREGATE_FUNCTION
.
exampleβ
mysql [test]>select avg_merge(avg_state(1)) from d_table;
+-------------------------+
| avg_merge(avg_state(1)) |
+-------------------------+
| 1 |
+-------------------------+
keywordsβ
AGG_STATE, MERGE