8.35. SQLAlchemy Query Group By

• Group By

• Having

8.35.1. Group By

• https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.group_by

8.35.2. Having

• https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.having

>>> q = session.query(User.id).\
...             join(User.addresses).\
...             group_by(User.id).\
...             having(func.count(Address.id) > 2)