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.