MYSQL get maximum value from a specific date

Question

I have a table with years of temperature measurements.

Looks for the highest measured temperature, including the date of recording, from the current year only.

Try:

< /p>

SELECT timestamp, temperature AS max_temp
FROM table
WHERE
temperature = (SELECT max(temperature) FROM table
            WHERE timestamp >= '2023-01-01');

But now the records returned from the complete table show the highest measured temperature in 2023.

Who has the right way to go?

Answer 1

You can use the Year() function to extract the year part of the timestamp: Therefore, the modified query will be:

SELECT timestamp (timestamp) = max( of the table Year(CURDATE()) temperature);

Hope it works!