182

Neo4j Aggregation Functions

There is some aggregation functions used in Neo4j CQL just like we used in SQL. These functions are used in RETURN clause. It is similar to GROUP BY clause in SQL.

The aggregation functions are used with RETURN clause in MATCH command to work on a group of nodes and return some aggregated value.

A list of aggregation functions in Neo4j is given below:

Index	Function	Description
1.	COUNT()	COUNT() function is used to fetch the number of rows returned by MATCH command.
2.	MAX()	MAX() function is used to fetch the maximum value from a set of rows returned by MATCH command.
3.	MIN()	MIN() function is used to fetch the minimum value from a set of rows returned by MATCH command.
4.	SUM()	SUM() function is used to fetch the summation value of all rows returned by MATCH command.
5.	AVG()	AVG() function is used to fetch the average value of all rows returned by MATCH command.