Hello All, I seem to be stuck on this query. A Customer can have multiple AccountTypes which can have multiple entries by Date. I am trying to query the most recent Date for each AccountType per Customer.
So, looking at the below sample I would want to return rows 3,4,&5 (row 1 is the field names) for Customer ABC and rows 6&8 for Customer DEF. These rows contain the most recent Date per AccountType.
Any thoughts on how I can accomplish this? Thanks.
So, looking at the below sample I would want to return rows 3,4,&5 (row 1 is the field names) for Customer ABC and rows 6&8 for Customer DEF. These rows contain the most recent Date per AccountType.
Any thoughts on how I can accomplish this? Thanks.
|