Using LAG but how do I fill in the final row of a group?
I’m currently using the following code so that the to_date column is filled with the last date that person had come to a specific shop.
I’m currently using the following code so that the to_date column is filled with the last date that person had come to a specific shop.