Thanks Cliff. But i don´t think it is that simple, or perhaps it is, but i
can't manage to build the right query.
If i use group by, it groups by the id and the having=max is ignored. all
ids appear.
Probably it needs joins. Will try to do the raw query and see if anyone can
translate it. Thanks
The DAL chapter of the online Web2py manual explains how to fetch the max
value, same as a SQL GROUP BY.
On Monday, March 10, 2014 3:54:59 PM UTC-4, brahama von wrote:
>
> This is the result i get from a simple select like this:
>
> legacy_db(legacy_db.cursodado.gp_pro_id==course).select()
>
> cu
2 matches
Mail list logo
