How to fetch from a MySQL database?

Question

PHP

Hello colleagues!
There is an entity with attributes name and date
Using php, we send a mysql query to the selection
. We need to get from all names one by one with the largest date .
Example
Let's say we have the following table:

Name | Date
-----------------
Петя | 10.02.2014
Петя | 21.05.2013
Ваня | 21.05.2013
Петя | 30.07.2015
Ваня | 03.10.2012
Даня | 12.08.2014

We get the following lines:

Петя | 30.07.2015
Ваня | 21.05.2013
Даня | 12.08.2014

That is, the names are not repeated, but among the same names the line with the largest date is selected
. Is it possible to implement this with one request?
PS The dates in the database are in the correct format.
This is just for illustration purposes .

Answer 1

SELECT DISTINCT `name`, `date` FROM `table` ORDER BY `date`

Answer 2

select
max(`Date`), `Name`
from `Tbl`
group by `Name`