tags:

views:

45

answers:

1
Q: 

SQLAlchemy 0.5.8 Max function

using SQLAlchemy 0.5.8 how do you run a max query?

i.e. Select max(id) from some_table

A:  
from sqlalchemy import func 

session.query(func.max(Table.column))
John  2010-09-20 13:00:31

related questions

Filtering by relation count in SQLAlchemy
IronPython db-api 2.0
sqlalchemy, turning a list of IDs to a list of objects
SQLAlchemy DateTime timezone
Mysql connection pooling question: is it worth it?
SQLAlchemy with count, group_by and order_by using the ORM
How do I ORDER BY an arithmetic express in SQLAlchemy?
How do I put a SQLAlchemy label on the result of an arithmetic expression?
Best way to organize the folders containing the SQLAlchemy models
What is the sqlalchemy equivalent column type for 'money' and 'OID' in Postgres?
Efficiently updating database using SQLAlchemy ORM
How to add an automatic filter to a relation with SQLAlchemy?
How to find out if a lazy relation isn't loaded yet, with SQLAlchemy?
How to specify relations using SQLAlchemy declarative syntax?
Group by date in a particular format in SQLAlchemy
Does SQLAlchemy support caching?
What's the easiest way/best tutorials to get familiar with SQLAlchemy ?
Pylons with Elixir
How can I use UUIDs in SQLAlchemy?
SQLAlchemy and kinterbasdb in separate apps under mod_wsgi
Is it OK to inspect properties beginning with underscore?
Opinions on DBCook?
Best way to access table instances when using SQLAlchemy's declarative syntax.
Getting random row through SQLAlchemy
User Authentication in Pylons + AuthKit