Hi. I tried:
select ( select expand( select date, COUNT(ip) as IpNo from Downloads group by date order by date asc) ) where IpNo >= 5 It still returns nothing. On Tuesday, December 23, 2014 12:06:47 AM UTC+2, Lvc@ wrote: > > Mihai, > You should use expand() in the inner query. > > Lvc@ > > > On 22 December 2014 at 10:25, Mihai Dinca <[email protected] <javascript:>> > wrote: >> >> I tried using nested queries, but it returns nothing. >> >> My query is like this: >> >> select (select date, COUNT(ip) as IpNo from Downloads group by date order >> by date asc) where IpNo >= 5 >> >> On Friday, December 19, 2014 4:14:20 PM UTC+2, GoorMoon wrote: >>> >>> 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 >>> >> -- >> >> --- >> 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.
