Hi there,
apologies in advance: I have a set of data, 3 columns: id, accountid & created date. id is unique, accountid & created date are not unique.
I need to select id, accountid where the created date is the highest/most recent, for each unique group of id and accountid.
SELECT...