Return x,count(*) as c Order by c desc Limit 1 Gives you the value of x that has the highest frequency
Von meinem iPhone gesendet > Am 29.07.2016 um 21:03 schrieb Marwa Elabri <[email protected]>: > > For example i have a vector of variable (00101) and i want to calculate the > mode of this vector > The occurece of the variable 0 =3 and the occurence of the variable 1 =2 > The variable 0 have the max of occurence so the mode of our vector is the > variable 0 > > So i want a query cypher that can do this > 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/d/optout. -- 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/d/optout.
