I have a table which contains customer id and visit date . I want to create a new column which holds the next visit date. Example. If a customer has 3 visits. I wish to see the second visit date on the new column of the same row of first visit and so on.
I feel it could be done by creating an index column but I am not completely sure on how to make do it. Attaching an image to explain my requirement.