Like SQL, Neo4j CQL has provided a few aggregation functions to apply in RETURN clause. It is similar to GROUP BY clause in SQL.
We can use this RETURN + Aggregation Functions in MATCH command to paintings on a group of nodes and go back some aggregated price.
AGGREGATION Functions List
Following is the list of aggregation capabilities 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. |