Return goes before Order by? MATCH (s:VcfRecord)--(v:VcfMeta) WITH s,v,count(v) as mycount WHERE mycount > 1 RETURN id(s),v ORDER BY id(s) DESC LIMIT 100
On Tue, Jan 14, 2014 at 7:04 PM, Alex Frieden <a...@frieden.org> wrote: > trying to run: *MATCH (s:VcfRecord)--(v:VcfMeta) WITH s,v,count(v) as > mycount WHERE mycount > 1 ORDER BY id(s) DESC RETURN id(s),v LIMIT 100* > > Getting error: > > Caught: Invalid input 'D' (line 1, column 84) > "MATCH (s:VcfRecord)--(v:VcfMeta) WITH s,v,count(v) as mycount WHERE > mycount > 1 ORDER BY id(s) DESC RETURN id(s),v LIMIT 100" > > ^ > Invalid input 'D' (line 1, column 84) > "MATCH (s:VcfRecord)--(v:VcfMeta) WITH s,v,count(v) as mycount WHERE > mycount > 1 ORDER BY id(s) DESC RETURN id(s),v LIMIT 100" > > Thanks! > > -- > 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+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > -- 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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.