Simple example : select announcementNumber, count(*) as total from Announcement group by announcementNumber
I get a list of announcementNumber s and another column named total with values ranging from 1 to 5 For my case here I just want to have an output when the total value excedes 1: select announcementNumber, count(*) as total from Announcement where total > 1 group by announcementNumber returns nothing. Workaround I used : select * from ( select announcementNumber, count(*) as total from Announcement group by announcementNumber ) where total > 1 On a side note, if I don't use "AS" to define the name I want to give the columns, like so : select announcementNumber, count(*) from Announcement where count(*) > 1 group by announcementNumber it return everything, like it did without the Where clause. -- --- 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.
