Query most number of friends

[Jason]

Person has some friends.

How do we list the name of the Person node with the most number of friends? 

Thanks

[Michael Hunger]

this is a very common query listed everywhere in the docs and training material.

match (p:Person)-[:FRIEND_OF]->()

return p, count(*) as c

order by c desc limit 10

faster:

match (p:Person)

return p, size( (p)-[:FRIEND_OF]->() ) as c

order by c desc limit 10

--
You received this message because you are subscribed to the Google Groups "Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Jason]

Hi Michael,

Thanks.

You answer return will like this 

A    6

B    5

C    4

But I want this

A    6

B    6

Any revision? Thanks

[Clark Richey]

I just noticed you use of a size function here. Is that a recent addition? I can’t find documentation on that. Thanks!

Clark Richey

clark....@gmail.com

[Benoit Simard]

Hi,

@Jason : I don't understand what you want exactly, and specially why B haven't the same
result on your queries ...

@Clark :

You can find documentation on snapshot (so for 2.3-SNAPSHOT) cypher refcard : http://neo4j.com/docs/snapshot/cypher-refcard/ (@see patterns section)

I can tell you that this works on a 2.1.8 version. But, I can't tell you when this was adding to cypher.

Cheers.