Like Luca say OrientDB does not support HAVING keyword. use nested query look in the wiki http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL.html#having
On Friday, December 19, 2014 3:49:25 PM UTC+2, Mihai Dinca wrote: > > 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]> 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.
