I sort the rows on date. If I want to select every row that has a unique value in the last column, can I do this with sql?

So I would like to select the first row, second one, third one not, fourth one I do want to select, and so on.

![enter image description here](https://i.stack.imgur.com/RowNd.png)