[web2py] How do I get last row for each type from table?

[Hans Cr]

I want my controller to return the last ('updated') row for each 'sid', 
given a specified 'gid'. 'sid' is multiple times in the table, but I want 
to have the last row. Can anyone help me?

Thanks a lot in advance!

Hans


db.define_table('value',
    Field('gid', 'string'),
    Field('sid', 'string'),
    Field('value', 'integer', required=True),
    Field('updated', 'datetime', default=request.now, writable=False, 
readable=False),
    format = '%(value)s')

--