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. |