Good day everyone and welcome back to SQL Something!
Today we're looking at an issue that was presented to me today: How to get the last record in a one to many relationship.
Some digging online found this original post here, which I then had to deconstruct to understand it. To that end, I made a couple test tables and then went through the query, while making small modifications to suit my needs.
Let's go through it.
