Get the distinct rows with oldest date

I have a table like this:

MyTable:     id: pk     numero: varchar     data_modif: timestamp     ...  

I have multiple records with same value in numero and I need to return each distinct numero record with oldest data_modif. How can I do this?

https://stackoverflow.com/questions/66586443/get-the-distinct-rows-with-oldest-date March 12, 2021 at 12:21AM