Group by count function in sqlalchemy

Question

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

User · Answer

You can also count on multiple groups and their intersection:

self.session.query(func.count(Table.column1),Table.column1, Table.column2).group_by(Table.column1, Table.column2).all()

The query above will return counts for all possible combinations of values from both columns.

User · Answer

If you are using Table query property   from sqlalchemy import func Table query with entities Table column  func count Table column   group by Table column  all     If you are using session query   method  as stated in miniwark s answer    from sqlalchemy import func session query Table column  func count Table column   group by Table column  all

User · Answer

The documentation on counting says that for group by queries it is better to use func count     from sqlalchemy import func session query Table column  func count Table column   group by Table column  all

[python] Group by & count function in sqlalchemy

Examples related to python

Examples related to group-by

Examples related to count

Examples related to sqlalchemy