You could do db(db.people.city == "London").select(orderby=db.people.age).first() >
On Saturday, January 2, 2016 at 8:12:31 AM UTC-5, UG wrote: > > Hi, > > If i have the following table > ID > fist_name > last_name > city > age > > > I use the MIN to find the lowest age > > youngest = db(db.people.city == > "London").select(db.people.age.min()).first() > > This will only give me the lowest age in the city. Is there a way to get > the complete record in the first query without having to resort to a second > query like > > result = db(db.people.age == youngest & db.people.city == > "London").select() > > Thanks > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" 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.
