Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF';
CREATE TABLE table_name (ID, TIME) AS
SELECT 1, TIMESTAMP '2022-06-14 11:33:03' FROM DUAL UNION ALL
SELECT 1, TIMESTAMP '2022-06-14 11:34:01' FROM DUAL UNION ALL
SELECT 1, TIMESTAMP '2022-06-14 11:34:40' FROM DUAL UNION ALL
SELECT 1, TIMESTAMP '2022-06-14 11:35:59' FROM DUAL UNION ALL
SELECT 1, TIMESTAMP '2022-06-14 11:38:00' FROM DUAL UNION ALL
SELECT 1, TIMESTAMP '2022-06-14 11:38:50' FROM DUAL;
6 rows affected

SELECT id,
       grp,
       MIN(time) AS start_time,
       MAX(time) AS end_time
FROM   (
  SELECT id,
         time,
         SUM(grp_change) OVER (PARTITION BY id ORDER BY time) AS grp
  FROM   (
    SELECT t.*,
           CASE
           WHEN time - LAG(time) OVER (PARTITION BY id ORDER BY time) <= INTERVAL '1' MINUTE
           THEN 0
           ELSE 1
           END AS grp_change
    FROM   table_name t
  )
)
GROUP BY id, grp;


ID
GRP
START_TIME
END_TIME


1
2
2022-06-14 11:35:59.000000000
2022-06-14 11:35:59.000000000

1
3
2022-06-14 11:38:00.000000000
2022-06-14 11:38:50.000000000

1
1
2022-06-14 11:33:03.000000000
2022-06-14 11:34:40.000000000

ID	GRP	START_TIME	END_TIME
1	2	2022-06-14 11:35:59.000000000	2022-06-14 11:35:59.000000000
1	3	2022-06-14 11:38:00.000000000	2022-06-14 11:38:50.000000000
1	1	2022-06-14 11:33:03.000000000	2022-06-14 11:34:40.000000000