Hello, I have this query match (c1:CI)-[:USES]->(c2:CI) return distinct c1.name,c2.name Now I would like to count the rows, but I don't seem to be able to figure this out! I tried return count(*) but this does count duplicates. I tried return count (distinct c1.name) but this is wrong, as it…

Hello @dario.piantanida and welcome to the Neo4j community :slight_smile: MATCH (c1:CI)-[:USES]->(c2:CI) WITH DISTINCT c1.name AS c1_name, c2.name AS c2_name RETURN count(c1_name) AS couples Regards, Cobra

How to count distinct couples

Neo4j Graph Platform Cypher

cobra (Cobra) January 8, 2021, 11:02am 2

Hello @dario.piantanida and welcome to the Neo4j community

MATCH (c1:CI)-[:USES]->(c2:CI)
WITH DISTINCT c1.name AS c1_name, c2.name AS c2_name
RETURN count(c1_name) AS couples

Regards,
Cobra

Topic		Replies	Views
Count distinct pairs i.e. Count rows "after" RETURN distinct a, b Cypher	5	3951	May 6, 2020
Count two relationships in one MATCH separately Neo4j Graph Platform counts	4	1320	December 17, 2019
Count distinct value for a relationship property Cypher	2	1026	January 18, 2021
Different About Relations Count() in Cypher Cypher relationship , counts	2	2987	May 25, 2019
Count all relationships when there are two MATCH patterns Neo4j Graph Platform	5	952	January 9, 2020

How to count distinct couples

Related topics