
Like SQL, Neo4j CQL has provided some aggregation functions to use in RETURN clause. It is similar to GROUP BY clause in SQL.
We can use this RETURN + Aggregation Functions in MATCH command to work on a group of nodes and return some aggregated value.
Following is the list of aggregation functions in Neo4j.
| Sr.No | Function & Description |
|---|---|
| 1 | COUNT
It returns the number of rows returned by MATCH command. |
| 2 | MAX
It returns the maximum value from a set of rows returned by MATCH command. |
| 3 | MIN
It returns the minimum value from a set of rows returned by MATCH command. |
| 4 | SUM
It returns the summation value of all rows returned by MATCH command. |
| 5 | AVG
It returns the average value of all rows returned by MATCH command. |