Neo4j - Aggregation Function


Advertisements

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.

AGGREGATION Functions List

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.

Advertisements