I want to select the entire row which has the biggest name grouped by name and last.
But the thing is I want to select the entire row because i want to put the entire row into a structure and not just a few fields. In psedocode I want to do:
SELECT * WITH REGARDS TO MAX(Date)
GROUP BY name last.
How do I achieve this?
Name Last Date
Emil Larsson 200609
Emil Larsson 200611
Emil Larsson 200610