0.7 has support for window functions. I haven't tried it in a subquery.
http://www.sqlalchemy.org/docs/core/tutorial.html?highlight=window#window-functions
--
Mike Conley
On Wed, Jul 27, 2011 at 9:16 AM, Eduardo wrote:
> I have the following statement :
>
> SELECT name, id, division, value,
I have the following statement :
SELECT name, id, division, value,
FROM (
SELECT name, id, division,value, max(value) over
(partition by division) as max_val
FROM tab1
)
WHERE value = max_val
I try to turn this sql statement into a Query object
I tried t