Oracle 11g Release 2

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

select * from V$VERSION;


BANNER


Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

PL/SQL Release 11.2.0.2.0 - Production

CORE 11.2.0.2.0 Production

TNS for Linux: Version 11.2.0.2.0 - Production

NLSRTL Version 11.2.0.2.0 - Production


create table t1 (id, ts) as 
    select 1, timestamp'2021-04-05 10:02:54' from dual union all 
    select 1, timestamp'2021-04-05 10:02:58' from dual union all
    select 1, timestamp'2021-04-05 13:28:02' from dual union all
    select 2, timestamp'2021-04-05 11:02:54' from dual
4 rows affected

with q as (
    select 
        q.*, case when (q.ts-prev) > interval '2' minute then 'y' end matched from (
        select t1.*, lag (t1.ts, 1, date'-4712-01-01') over (partition by id order by t1.ts asc) prev
    from t1) q)
select q.id, to_char (q.ts, 'dd.mm.yyyy hh24:mi:ss') time
from q
where matched = 'y'


ID
TIME


1
05.04.2021 10:02:54

1
05.04.2021 13:28:02

2
05.04.2021 11:02:54

ID	TIME
1	05.04.2021 10:02:54
1	05.04.2021 13:28:02
2	05.04.2021 11:02:54