![Neo4j Tutorial](/neo4j/images/neo4j-mini-logo.jpg)
- Neo4j Tutorial
- Neo4j - Home
- Neo4j - Overview
- Neo4j - Data Model
- Neo4j - Environment Setup
- Neo4j - Building Blocks
- 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 - Count Function
Assume we have created a graph in the database with the following details.
![Count Database](/neo4j/images/count_database.jpg)
Count
The count() function is used to count the number of rows.
Syntax
Following is the syntax of the count function.
MATCH (n { name: 'A' })-->(x) RETURN n, count(*)
Example
Following is a sample Cypher Query which demonstrates the usage of the count() function.
Match(n{name: "India", result: "Winners"})--(x) RETURN n, count(*)
To execute the above query, carry out the following steps −
Step 1 − Open the Neo4j desktop App and start the Neo4j Server. Open the built-in browser app of Neo4j using the URL http://localhost:7474/ as shown in the following screenshot.
![Browser App](/neo4j/images/browser_app.jpg)
Step 2 − Copy and paste the desired query in the dollar prompt and press the play button (to execute the query) highlighted in the following screenshot.
![Count Match](/neo4j/images/count_match.jpg)
Result
On executing, you will get the following result.
![Count Result](/neo4j/images/count_result.jpg)
Group Count
The COUNT clause is also used to count the groups of relationship types.
Example
Following is a sample Cypher Query which counts and returns the number of nodes participating in each relation.
Match(n{name: "India", result: "Winners"})-[r]-(x) RETURN type (r), count(*)
To execute the above query, carry out the following steps −
Step 1 − Open the Neo4j desktop App and start the Neo4j Server. Open the built-in browser app of Neo4j using the URL http://localhost:7474/ as shown in the following screenshot.
![Browser App](/neo4j/images/browser_app.jpg)
Step 2 − Copy and paste the desired query in the dollar prompt and press the play button (to execute the query) highlighted in the following screenshot.
![Group Count](/neo4j/images/group_count.jpg)
Result
On executing, you will get the following result.
![Group Count Result](/neo4j/images/group_count_result.jpg)
To Continue Learning Please Login