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 -~----------~----~----~----~------~----~------~--~---
