Hi, I have a dataset that has multiple entries for a particular customer, ordered by date. I'm trying to return all data for each customer based on the last two date entries - doing it for the last and first dates is easy enough, but I'm struggling on the last two date entries. Any suggestions at all are very welcome! Otherwise I'll end up having to run the whole thing in sequel, which I'd rather not do..
ThanksTammy
tamaragreen
Offline
Last seen: 5 years 5 months ago
Joined: 03/20/2018 - 05:29
Nevermind - I've sorted it! Was overcomplicating things and a top records extraction proved to be perfect!
Yes, you found the best option for doing something like this.