With a traditional SQL based database a HAVING clause will restrict aggregated values. For example
select zipcode, count(*) as population from Person group by zipcode having population>100000;
will return all zipcodes which have more than 100k residents. To achieve the same in Cypher use the following
match (n:Person) with n.zipcode as zip, count(*) as population where population>100000 return zip,population
- Last Modified: 2020-09-28 18:12:27 UTC by Dana Canzano.
- Relevant for Neo4j Versions: 3.0, 3.1, 3.2, 3.3.
- Relevant keywords sql.