Hi Anh Thanks for clearing my head. I had devised considerably more complex attempts!
So, the answer is; table.select().group_by(table.c.A).with_only_columns([table.c.A, func.count(1).label('count')]).execute().fetchall() :-) n 23/10/2013, at 7:29 PM, anh le <anh...@gmail.com> wrote: > Hi, > > Have you tried: > > select A, count(*) from the_table group by A > > On Wed, Oct 23, 2013 at 4:17 PM, Warwick Prince > <warwi...@mushroomsys.com> wrote: >> Hi All >> >> Please excuse this relatively noob question, but I can not for the life of >> me find the answer in docs. (Probably because I don't know what I'm looking >> for). >> >> I have a table with two columns A and B. "A" can have many duplicate >> values. e.g. >> >> A B >> -------- >> 1 a >> 1 b >> 1 c >> 1 d >> 2 f >> 2 g >> 3 z >> >> I want to have a result that returns all the values of A, and how many times >> they appear in the table. >> >> Sample result from above would be; >> >> 1 4 >> 2 2 >> 3 1 >> >> Clearly, I'm no SQL wizz, so I have the added issue of not knowing the raw >> SQL, let alone SQLAlchemy's take on it. >> >> If you can provide the answer using table.select() type query, rather than >> the ORM equivalent it would be most appreciated. :-) >> >> Thanks in anticipation. >> >> Cheers >> Warwick >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to sqlalchemy+unsubscr...@googlegroups.com. >> To post to this group, send email to sqlalchemy@googlegroups.com. >> Visit this group at http://groups.google.com/group/sqlalchemy. >> For more options, visit https://groups.google.com/groups/opt_out. > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.