CODEWITHSUNDEEP
neo4jcypher
Milad ranjbar
Milad ranjbar

Reputation: 589

How to find the most connected node of particular relationship type in neo4j using cypher query?

Can some one help me to find the most connected node of particular relationship type in neo4j using cypher query.

Suppose I have

Node1      Node2     Relationship
A             B             follows
A             C             follows
B             D             follows

A             D             follows

Here Node D is the most connected node.of particular relationship type "Follows" .so how to find this node using cypher query?

Thanks in Advance

(Edit): i found my answer tnx Martin Preusse

    MATCH (n)<-[r:FOLLOWS]-()
    RETURN n, count(r) AS num
    ORDER BY num desc

Upvotes: 6

Views: 3074

Answers (1)

Martin Preusse
Martin Preusse

Reputation: 9369

Try this if the direction of the relationship matters (will only return A and B):

MATCH (n)-[r:follows]->()
RETURN n, count(r) AS num
ORDER BY num

Or this if you don't need the direction (i.e. the node D will be returned as well):

MATCH (n)-[r:follows]-()
RETURN n, count(DISTINCT r) AS num
ORDER BY num

Upvotes: 7

Related Questions