tags:

views:

383

answers:

2
Q: 

Group by & count function in sqlalchemy

I want a "group by and count" command in sqlalchemy. How can I do this?

+1  A:  
session.query(TABLENAME).group_by(TABLENAME.colum).count()
dalloliogm  2009-07-27 17:34:51

related questions

How do I include empty rows in a single GROUP BY DAY(date_field) SQL query?
Complex join with nested group-by/having clause?
Using Linqdatasource and groupby property
How can I read LINQ group by Query?
SQL "group by" question - I can't select every column
Table Group By - Tsql -
MySQL - Control which row is returned by a group by.
Optmizing MySQL GROUP BY or DISTINCT on large views
How to get list of values in GROUP_BY clause?
SQL select nth member of group
How to lambda the group by data on a LINQ to Sql results?
MSSQL: Only last entry in GROUP BY
MySQL Query - getting missing records when using group-by
sql group by versus distinct
Grouping List by the last Char
Why does SQL force me to repeat all non-aggregated fields from my SELECT clause in my GROUP BY clause?
SQL group by date, but get dates w/o records too
MySQL finding subtotals
SQL expression problem
C# List<> GroupBy 2 Values
How would I calculate timespans from a list of check in and check outs?
"Most popular" GROUP BY in LINQ?
How do I return my records grouped by NULL and NOT NULL?
How to concatenate strings of a string field in a PostgreSQL 'group by' query?
How do I use T-SQL Group By