Finding earliest date in a cluster
I have multiple rows for a customer and each row has a modified on date. I want to find the earliest date (most recent date) in the cluster.
Clusterid modified date
Therefore for cluster 1 give me the full row based on this modified date - 03-08-2009
For cluster 2, full row for the one with 01-01-2020
is there an easy way to flag the row with the most recent in the cluster and then just select that row for each cluster?
thanks for your assistance