Is there a way to SELECT from my (SQLite) db with example structure/data that looks like this:
sue | dog | cat | dog joe | cat | rat | dog joe | dog | dog | rat joe | cat | cat | cat tom | rat | dog | dog a counted, grouped-by set for JOE only that looks like: cat - 4 dog - 3 rat - 2 I've been playing with selecting Joe's records, then looping over them building subtotals in a dict, but this seems a huge waste of effort and my data is actually much larger so I am worried about performance as I try to scale this. From what I read the groupby is for by fields only, not by counted values? Can anyone point me in the right direction? thanks! -- --- 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.
