Perfect thanks!
On Tue, Jan 14, 2014 at 9:01 AM, Luanne Coutinho <[email protected]>wrote: > 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 <[email protected]> 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 [email protected]. >> 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 [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- Alexander Frieden -- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
