I use Orientdb JDBC driver. I also updated to 2.0-M3 version I get: Invalid keyword 'HAVING' at com.orientechnologies.orient.core.sql.OCommandExecutorSQLAbstract.throwParsingException(OCommandExecutorSQLAbstract.java:92) .......
On Friday, December 19, 2014 3:00:45 PM UTC+2, Lvc@ wrote: > > 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] <javascript:>> > 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] <javascript:>. >> 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.
