- Neo4j CQL Write Clauses
- Neo4j - Merge Command
- Neo4j - Set Clause
- Neo4j - Delete Clause
- Neo4j - Remove Clause
- Neo4j - Foreach Clause
- Neo4j CQL Read Clause
- Neo4j - Match Clause
- Neo4j - Optional Match Clause
- Neo4j - Where Clause
- Neo4j - Count Function
- Neo4j CQL General Clauses
- Neo4j - Return Clause
- Neo4j - Order By Clause
- Neo4j - Limit Clause
- Neo4j - Skip Clause
- Neo4j - With Clause
- Neo4j - Unwind Clause
- Neo4j CQL Functions
- Neo4j - String Functions
- Neo4j - Aggregation Function
- Neo4j CQL Admin
- Neo4j - Backup & Restore
- Neo4j - Index
- Neo4j - Create Unique Constraint
- Neo4j - Drop Unique
- Neo4j Useful Resources
- Neo4j - Quick Guide
- Neo4j - Useful Resources
- Neo4j - Discussion
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