I have a mysql table that contains all the subscribed plan by users. I am trying to create a SELECT statement that will allow me to select for a particular user from the table. Also, if that user have duplicated entries, it will get the latest date of all.
For example, I want to look for John from the table and the date I should get is 2015-09-10.
Subscribed table
ID FirstName Date
-------------------------------
1 John 2015-05-30
2 Mary 2014-01-10
3 John 2015-09-10
4 John 2015-03-15
5 Loen 2013-12-11
How should I go about creating the SELECT statement to above the result?