Search code examples
sqlalchemy

SQLAlchemy max function


Using SQLAlchemy how do you run a max query?

For example

SELECT max(id) FROM some_table

Solution

  • from sqlalchemy import func 
    
    session.query(func.max(Table.column))