use aggregate functions in the WHERE clause (Neo4j)

Question

How do I select all nodes that are connected to node(2) [from] with more than one path? ``` START from=node(2) MATCH p=from-->to where count(p) > 1 return from,to ``` To Neo4J team : Any plans to implement Count/Having functions? great job so far with the product!

Accepted Answer

actually found the solution combining the 'WITH' keyword

```
START from=node(*) 
MATCH p=from-->to 
WITH from as from , to as to, count(p) as paths 
WHERE paths >1 
RETURN to,paths
```

use aggregate functions in the WHERE clause (Neo4j)

Solution

Problem