MIN() - Frage - Extremwert finden

[Andreas-123]

Was sagt
SELECT MIN(Temperatur), DatumZeit FROM my_table WHERE DatumZeit > (NOW() - INTERVAL 1 YEAR)

Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

(...) supplied argument is not a valid MySQL result resource in (...)

Andreas