I have a select SQL query on Mysql that returns a result in the form with two columns:

```
number  date
1       date1
1       date2
2       date3
.
.

```

How do you i select from the select query and keep only the most recent date for each number.

I have problems working the query result.