I have a table as follows:
Name Customer Date Amount Joe Aaron 11/11/2017 150 Joe Ron 13/11/2017 150 Joe Danny 15/11/2017 150 Joe Karen 11/12/2017 150 Ronald Blake 21/1/2017 1501
I would like to query to retrieve data by specifying the
Name and getting the details by the latest date.
For example, if I want to query
Joe, I will get the following result:
Name Customer Date Joe Karen 11/12/2017
How should I do this? Tried
distinct but it doesnt work that way.