Neo4j::cypher aggregation

Read first how aggregation works here: http://docs.neo4j.org/chunked/1.8/query-aggregation.html

Count

COUNT is used to count the number of rows. COUNT can be used in two forms — COUNT(*) which just counts the number of matching rows, and COUNT(), which counts the number of non-null values in .

Example, count my friends

node(1).outgoing(:friends).count 

Same as START v2=node(1) MATCH (v2)-[:friends]->(v1) RETURN count(v1)

Example: To count the number of nodes, for example the number of nodes connected to one node, you can use

ret node(1).outgoing,count

Same as START v1=node(1) MATCH (v1)-->(v2) RETURN v2,count(*)