I have below data in my table:
eff_dt end_dt type_cd status1-Jan-14 5-Jan-14 AAA 05-Jan-14 7-Jan-14 null 17-Jan-14 10-Jan-14 null 110-Jan-14 15-Jan-14 BBB 015-Jan-14 21-Jan-14 null 121-Jan-14 25-Jan-14 null 125-Jan-14 30-Jan-14 CCC 0
I want to update data using self join .
After update table should look like:
eff_dt end_dt type_cd status1-Jan-14 5-Jan-14 AAA 05-Jan-14 7-Jan-14 AAA 17-Jan-14 10-Jan-14 AAA 110-Jan-14 15-Jan-14 BBB 015-Jan-14 21-Jan-14 BBB 121-Jan-14 25-Jan-14 BBB 125-Jan-14 30-Jan-14 CCC 0
Please help me with the update query in teradata ?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.