[web2py] Re: How to select only 10 last rows in a table?

[Annet]

Hi Vladimir,

Some time ago Anthony provided me with the following solution:

maxID=db(db.node).select(db.node.id.max()).first()['MAX(node.id)']
rows=db(db.node.id>=maxID-10).select(db.node.id,db.node.computedName,orderby=~db.node.id)


Kind regards,

Annet

--