Teradata SQL，teradatasql
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!!!
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。