With Cypher, I'm trying to return the node of the highest score. However it either just returns the score without any id to the node, what do I need to add to my query?
start n=node(*) WHERE HAS(n.score) return MAX(n.score);
Asked
Active
Viewed 3,143 times
4
Mohamed Ismail Mansour
- 1,053
- 11
- 22
CoffeeCoder
- 103
- 2
- 11
1 Answers
4
This solution should give you both the score and node.
start n=node(*) WHERE HAS(n.score) RETURN n, n.score ORDER BY n.score LIMIT 1
bornytm
- 793
- 1
- 11
- 27
-
but n will return the whole collection of nodes and not just the node with the highest score – CoffeeCoder Jul 18 '13 at 22:14
-
Oops. I've edited my answer to what should be a working solution. – bornytm Jul 18 '13 at 23:20
-
1if I do start n=node(*) WHERE HAS(n.score) RETURN n, n.score ORDER BY n.score DESC Limit 1; that works, the other way would give me the lowest score. – CoffeeCoder Jul 19 '13 at 05:55
-
How does this solution work in terms of performance with large set of nodes? – user_mda Sep 16 '16 at 18:03