Find rows that have the same value and select the newer one

I got a table, that looks like this:

From rows with the same sensorNr, I only want to select those with newer ModifyDate, so the result should look like this:

How can I achieve that?

>Solution :

On MySQL 8+, we can use ROW_NUMBER here:

WITH cte AS (
    SELECT *, ROW_NUMBER() OVER (PARTITION BY sensorNr ORDER BY ModifyDate DESC) rn
    FROM yourTable
)

SELECT serialNr, sensorNr, ModifyDate
FROM cte
WHERE rn = 1;