I'd like to calculate a MAX() value for a column. What's the proper way to do this in sqlalchemy开发者_运维知识库 while preserving database independence?
You can find aggregate functions in:
from sqlalchemy import func
func.avg(...)
func.sum(...)
func.max(...)
In 0.5 you can use an ORM query like a select:
session.query(func.max(Table.column))
精彩评论