Select newest records that have distinct Name column

[eleteroboltz]

I'm trying to query a table and instead of showing all duplicate names, I want it to show only the newest record of each name.

I tried to do the query but I did not succeed.

Congratulations for the great work and thank you in advance.

Exemple: Original table
ID| Name | Price | Date
0 | A | 10 | 2017-01-21
1 | B | 09 | 2017-02-22
2 | A | 08 | 2017-03-23
3 | C | 10 | 2017-04-15
4 | B | 08 | 2017-05-19

Desired result
ID| Name | Price | Date
2 | A | 08 | 2017-03-23
3 | C | 10 | 2017-04-15
1 | B | 09 | 2017-05-19