Finally I solved it with HAVING which I didn't know was supported Thank you all anyways
Marcos On Jun 10, 6:05 pm, mdipierro <[email protected]> wrote: > I do not think that is possible but I may be wrong. If you teach how > to do it in SQL I will tell you how to translate in web2pyese. > > Massimo > > On Jun 10, 3:18 pm, Marcos Prieto <[email protected]> wrote: > > > Hi, > > > I'm trying to do a query in which I use select() with count and > > groupby > > > db().select(field1, field1.count(), groupby=field2) > > > but I'd like to be able to use the count column to limit the results, > > adding a where clause to the SQL, something like "where count > x" > > > Is that possible? how? > > > Thanks, > > > Marcos. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
