Neo4j – Aggregation Function


Neo4j – Aggregation Function


”;


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

”;

Leave a Reply

Your email address will not be published. Required fields are marked *