Styjun

Is camera lens focus an exact point or a range?

Varistor? Purpose and principle

Find last 3 digits of this monster number

Folder comparison

Java - What do constructor type arguments mean when placed *before* the type?

Melting point of aspirin, contradicting sources

How do I repair my stair bannister?

What is this type of notehead called?

Why did the EU agree to delay the Brexit deadline?

Should I stop contributing to retirement accounts?

Can I use my Chinese passport to enter China after I acquired another citizenship?

How do I implement a file system driver driver in Linux?

Difference between -| and |- in TikZ

Is a model fitted to data or is data fitted to a model?

Open a doc from terminal, but not by its name

Can a significant change in incentives void an employment contract?

How can "mimic phobia" be cured or prevented?

Has Darkwing Duck ever met Scrooge McDuck?

How will losing mobility of one hand affect my career as a programmer?

Freedom of speech and where it applies

Some numbers are more equivalent than others

Could the E-bike drivetrain wear down till needing replacement after 400 km?

What does the Rambam mean when he says that the planets have souls?

Did arcade monitors have same pixel aspect ratio as TV sets?

SQLAlchemy Min/Max Aggregates with Constraint on Join

Python join: why is it string.join(list) instead of list.join(string)?Convert sqlalchemy row object to python dictWhat's the difference between filter and filter_by in SQLAlchemy?Getting the index of the returned max or min item using max()/min() on a listSQLAlchemy 0.5.8 Max functionSQLAlchemy ORDER BY DESCENDING?SQLAlchemy: What's the difference between flush() and commit()?Using OR in SQLAlchemySQLAlchemy IN clausesqlalchemy simple example of `sum`, `average`, `min`, `max`

0

I am trying to translate the following, rather simple SQL into a sensible SQLAlchemy statement, but fail on how to construct it from first prinicples:

SELECT Min(t1.col) as col_min, MAX(t1.col) as col_max
FROM table1 as t1
INNER JOIN table2 as t2 ON t1.id = t2.join_id
GROUP BY t2.some_field
HAVING t2.some_field == 'constrain';

as a side node (doesn't affect this problem much, but might be useful for optimization of this query), the mapping between t1 and t2 is many-to-one and there is only exactly one element in t2, which will fulfill the constraint.

python sqlalchemy

share|improve this question

asked Mar 21 at 13:39

mzollmzoll

35728

add a comment | 

0

I am trying to translate the following, rather simple SQL into a sensible SQLAlchemy statement, but fail on how to construct it from first prinicples:

SELECT Min(t1.col) as col_min, MAX(t1.col) as col_max
FROM table1 as t1
INNER JOIN table2 as t2 ON t1.id = t2.join_id
GROUP BY t2.some_field
HAVING t2.some_field == 'constrain';

as a side node (doesn't affect this problem much, but might be useful for optimization of this query), the mapping between t1 and t2 is many-to-one and there is only exactly one element in t2, which will fulfill the constraint.

python sqlalchemy

share|improve this question

asked Mar 21 at 13:39

mzollmzoll

35728

add a comment | 

I am trying to translate the following, rather simple SQL into a sensible SQLAlchemy statement, but fail on how to construct it from first prinicples:

SELECT Min(t1.col) as col_min, MAX(t1.col) as col_max
FROM table1 as t1
INNER JOIN table2 as t2 ON t1.id = t2.join_id
GROUP BY t2.some_field
HAVING t2.some_field == 'constrain';

as a side node (doesn't affect this problem much, but might be useful for optimization of this query), the mapping between t1 and t2 is many-to-one and there is only exactly one element in t2, which will fulfill the constraint.

python sqlalchemy

share|improve this question

asked Mar 21 at 13:39

mzollmzoll

35728

SELECT Min(t1.col) as col_min, MAX(t1.col) as col_max
FROM table1 as t1
INNER JOIN table2 as t2 ON t1.id = t2.join_id
GROUP BY t2.some_field
HAVING t2.some_field == 'constrain';

share|improve this question

asked Mar 21 at 13:39

mzollmzoll

35728

share|improve this question

asked Mar 21 at 13:39

mzollmzoll

35728

asked Mar 21 at 13:39

mzollmzoll

35728

asked Mar 21 at 13:39

mzollmzoll

35728