Here is an example of what I need to do. This is an example of my table data:
ID. Date
1 2020-04-14
3 2020-04-13
1 2020-04-12
2 2020-04-11
Would like the following results:
ID. Most Recent Date Count
1 2020-04-14 2
3 2020-04-13 1
2 2020-04-11 1
I just can’t get my head around how to write this query?
Community Page
Last updated:
Last updated: