I have a data set as below. country code snapshot date canada 1/3/2014 canada 1/4/2014 us 1/5/2014 us 1/6/2014 us 1/7/2014 canada 1/8/2014 canada 1/9/2014 I would like to create a result table as below. country code start snapshot date end snapshot date canada 1/3/2014 1/4/2014 us 1/5/2014 1/7/2014 canada 1/8/2014 1/9/2014 I can only create the start snapshot date by rank and join the same table, and am having trouble to get the end snapshot date.
... View more
