Thanks That is how i did it reading the book.
2013/4/24 Anthony <abasta...@gmail.com> > Not sure if this can be done completely with the DAL, but doing some > post-processing in Python: > > count = db.mytable.Name.count() > rows = db(db.mytable).select(db.mytable.Name, count, groupby=db.mytable. > Name) > odd_count_names = [r.mytable.Name for r in rows if r[count] % 1 == 0] > > Anthony > > > On Wednesday, April 24, 2013 7:24:01 AM UTC-4, Ramos wrote: >> >> 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. > > > -- --- 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.
