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 counts only the "users", not the distinct relationships.
Other attempts gave me error.
Could you help?
Tnx!