Re: [Neo4j] RETURN DISTINCT with ORDER BY
Thanks. I'll keep it in mind. On 30/11/2011, at 7:34 PM, Andres Taylor wrote: > On Wed, Nov 30, 2011 at 6:27 AM, dnagir wrote: >> >> But the query with both DISTINCT and ORDER BY doesn't return anything: >> > > There was a bug concerning distinct and order by in the same query that has > been solved now. It was fixed in the stable 1.5 release. My suggestion is > that you upgrade to that and report if you still have problems. > > Andrés > ___ > Neo4j mailing list > User@lists.neo4j.org > https://lists.neo4j.org/mailman/listinfo/user ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] RETURN DISTINCT with ORDER BY
Thanks. This does work indeed. Much like in SQL :) On 30/11/2011, at 6:37 PM, readic [via Neo4j Community Discussions] wrote: > try this: > start d=node(17) match d-[*0..99]->x return distinct x,x.name order by x.name > > If you reply to this email, your message will be added to the discussion > below: > http://neo4j-community-discussions.438527.n3.nabble.com/RETURN-DISTINCT-with-ORDER-BY-tp3547366p3547551.html > To unsubscribe from RETURN DISTINCT with ORDER BY, click here. > NAML -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/RETURN-DISTINCT-with-ORDER-BY-tp3547366p3547899.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] RETURN DISTINCT with ORDER BY
On Wed, Nov 30, 2011 at 6:27 AM, dnagir wrote: > > But the query with both DISTINCT and ORDER BY doesn't return anything: > There was a bug concerning distinct and order by in the same query that has been solved now. It was fixed in the stable 1.5 release. My suggestion is that you upgrade to that and report if you still have problems. Andrés ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] RETURN DISTINCT with ORDER BY
try this: start d=node(17) match d-[*0..99]->x return distinct x,x.name order by x.name -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/RETURN-DISTINCT-with-ORDER-BY-tp3547366p3547551.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
[Neo4j] RETURN DISTINCT with ORDER BY
Hi, I wonder how can I use both distinct and order by in the queries. These 2 work as expected: start d=node(17) match d-[*0..99]->x return x order by x.name start d=node(17) match d-[*0..99]->x return distinct x But the query with both DISTINCT and ORDER BY doesn't return anything: start d=node(17) match d-[*0..99]->x return distinct x order by x.name What am I missing here? Using v 1.5.M02 Thanks. -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/RETURN-DISTINCT-with-ORDER-BY-tp3547366p3547366.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user