Try Mihai, Try to search HAVING in our beautiful documentation: http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL.html#having
Lvc@ On 19 December 2014 at 13:56, Mihai Dinca <[email protected]> wrote: > > Hi. > > I want to do a select like: > select date, COUNT(ip) as IpNo from Downloads group by date having > COUNT(ip) >= 5 order by date asc > > Because sql contains an aggregate function, in sql we have to add the > filter in a HAVING clause instead a WHERE clause. > But OrientDB does not support HAVING. So, is there a way to do something > like this in OrientDB? > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" 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 "OrientDB" 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.
