Hi Maybe you could try something like
db().select(db.myTable.name=='Alex', groupby=db.myTable.name) Le mercredi 24 avril 2013 13:24:01 UTC+2, Ramos a écrit : > > hello, > i have a table like > > Name date > John 2013-01-01 > John 2013-01-01 > Alex 2013-02-02 > Alex 2013-02-03 > Alex 2013-02-04 > > How do i select only alex because he has odd number of records? > I just want the name alex, i dont care how many. > -- --- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.