I have a table with a date field and I need to get all of the records with the most recent date.
For example, if I have the following records, I need to get all of them with date 2017-11-09 only. which represent the most recent.
What would be a good approach?
2017-01-01
2017-01-01
I thought about issuing a SELECT DISTINCT to get one record for each date, ORDER BY date DESC and then LIMIT 1 so I finally get the most recent date and use it in the WHERE clause. But this seems to me a bit complex.
Respectfully,
Jorge Maldonado