I'm trying to calculate the rank of a particular (unique) row id by using a subquery:
I first calculate the total ranking for a table, Game (using 1.4.23): sq = ( session.query( Game.id, Game.score, func.rank().over(order_by=Game.score.desc()).label("rank"), ) .filter(Game.complete == True) .subquery() ) Then filter by the row ID I want (gameid): gamerank = ( session.query( sq.c.id, sq.c.score, sq.c.rank ) .filter(sq.c.id == gameid) .limit(1) .one() ) Game.score is a Float column. Is this the most efficient way to do this, or am I over-complicating it? -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/e0373046-8379-499f-b584-37eb032636b9n%40googlegroups.com.