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.
