select customer, effdate,
lag(eff_date) over(partition by customer order by eff_date) as previous_eff
from tablename;