Most recent record based on date column

I have a table loaded from an odatafeed with regular refreshes that has a lot of column but following 2 are the most important for this question;

table incidents

- incidentnumber

- modificationdate

Now every incidentnumber can have multiple records, based on the different values of a column. If an incident gets updated, a new row will be added in the table with that incidentnumber together with  a modificationdate value

I want this table to only show unique values of incidentnumbers, so no double incidentnumbers, and only those with the most recent modificationdate

So when there are a few records of incidentnumber 1322 in the table, with below modificationdate, only the last record should be in the table

Incidentnumber        modificationdate

1322                       20/09/2022 09:56:21

1322                       21/09/2022 09:56:21

1322                       21/09/2022 17:56:21

How can i do this? 🙂