Is it possible to get the maximim value (for example an age) for every different value (eg surname) in another field of the record??
For example the oldest person for every surname present in a surname column?
I've tried subqueries, distinct, etc and I cant get it.
For example the oldest person for every surname present in a surname column?
I've tried subqueries, distinct, etc and I cant get it.