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 <[email protected]> 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
> <[email protected]> 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 [email protected].
>> To post to this group, send email to [email protected].
>> 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 [email protected].
> To post to this group, send email to [email protected].
> 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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
