Teradata SQL 

select lstg_id, deal_start_dt, deal_end_dt, 
min(deal_start_dt) over (
partition by lstg_id order by deal_start_dt
reset when deal_start_dt>
max(deal_end_dt) over (partition by lstg_id order by 
deal_start_dt rows between unbounded preceding and 1 preceding )),
max(deal_end_dt) over (
partition by lstg_id order by deal_start_dt
reset when deal_start_dt>
max(deal_end_dt) over (partition by lstg_id order by 
deal_start_dt rows between unbounded preceding and 1 preceding ))
from app_compass_t.CMPS_LSTG_DLY_DEAL_HIST

 Teradata LOAP function with RESET. Very cool!!!

posted @ 2013-01-17 12:52  flowerbear  阅读(190)  评论(0)  编辑  收藏  举报