问如何从具有重叠期间的多个维的连续事务处理中导出起始日期和终止日期？

EN

select pernr, matr, min(CALDR_DT), max(CALDR_DT)
from (select t.*,
             row_number() over (partition by matnr order by CALDR_DT) as seqnum,
             row_number() over (partition by matnr, pernr order by CALDR_DT) as seqnum_1
      from t
     ) t
group by (seqnum - seqnum_1), matnr, pernr;

SELECT NORMALIZE -- normalize overlapping periods
   PERIOD(CALDR_DT, CALDR_DT+1) AS pd -- make the date a single day PERIOD
  ,PERNR
  ,LOC
  ,MATNR
FROM mytable

SELECT 
   Begin(pd)
  ,Last(pd)
  ,PERNR
  ,LOC
  ,MATNR
FROM
 (
   SELECT NORMALIZE -- normalize overlapping periods
      PERIOD(CALDR_DT, CALDR_DT+1) AS pd -- make the date a single day PERIOD
     ,PERNR
     ,LOC
     ,MATNR
   FROM mytable
 ) AS dt