SQL Server 2019

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

create table t (
id varchar(80),
transactiontimestamp datetime2(7),
transactionid varchar(20),
transactionreference varchar(20),
type varchar(20),
pki varchar(20),
pkp varchar(20));
insert into t
values
('7b787e6c1885dsf35','2022-03-11T13:42:10.0000000','448','orq','YRT','6432','2433'),
('7b787e6c1885dsf35','2022-03-11T13:42:13.0000000','1431','orq','YRT','6432','2433'),
('7b787e6c1885dsf35','2022-03-11T13:42:17.0000000','1432','orq','TIX','6432','2433'),
('7b787e6c1885dsf35','2022-03-11T13:42:19.0000000','449','orq','YRT','6432','2433'),
('7b787e6c1885dsf35','2022-03-11T13:42:23.0000000','1433','orq','TIX','6432','2433'),
('7b787e6c1885dsf35','2022-03-11T13:42:28.0000000','419','orq','YRT','6432','2433'),
('7b787e6c1885dsf35','2022-03-11T13:42:31.0000000','40','orq','YRT','6432','2433'),
('7b787e6c1885dsf35','2022-03-11T13:42:46.0000000','1434','orq','TIX','6432','2433'),
('7b787e6c1885dsf35','2022-03-11T13:42:48.0000000','450','orq','YRT','6432','2433'),
('7b787e6c1885dsf35','2022-03-11T13:42:50.0000000','1435','orq','YRT','6432','2433'),
('7b787e6c1885dsf35','2022-03-11T16:42:50.0000000','587','orq','YRT','6432','5342'),
('7b787e6c1885dsf35','2022-03-25T11:09:05.0000000','555','orq','TIX','6432','5342');
12 rows affected

select *
from (
  select *,
    case when id = lag(id) over(order by transactiontimestamp)
          and type = lag(type) over(order by transactiontimestamp)
          and pki = lag(pki) over(order by transactiontimestamp)
          and transactiontimestamp <= 
            dateadd(hour, 4, lag(transactiontimestamp) over(order by transactiontimestamp))
           or id = lead(id) over(order by transactiontimestamp)
          and type = lead(type) over(order by transactiontimestamp)
          and pki = lead(pki) over(order by transactiontimestamp)
          and transactiontimestamp <= 
            dateadd(hour, 4, lead(transactiontimestamp) over(order by transactiontimestamp))
    then 1 else 0 end as same_value
  from t
) x
where same_value = 1
order by transactiontimestamp


id
transactiontimestamp
transactionid
transactionreference
type
pki
pkp
same_value


7b787e6c1885dsf35
2022-03-11 13:42:10.0000000
448
orq
YRT
6432
2433
1

7b787e6c1885dsf35
2022-03-11 13:42:13.0000000
1431
orq
YRT
6432
2433
1

7b787e6c1885dsf35
2022-03-11 13:42:28.0000000
419
orq
YRT
6432
2433
1

7b787e6c1885dsf35
2022-03-11 13:42:31.0000000
40
orq
YRT
6432
2433
1

7b787e6c1885dsf35
2022-03-11 13:42:48.0000000
450
orq
YRT
6432
2433
1

7b787e6c1885dsf35
2022-03-11 13:42:50.0000000
1435
orq
YRT
6432
2433
1

7b787e6c1885dsf35
2022-03-11 16:42:50.0000000
587
orq
YRT
6432
5342
1

id	transactiontimestamp	transactionid	transactionreference	type	pki	pkp	same_value
7b787e6c1885dsf35	2022-03-11 13:42:10.0000000	448	orq	YRT	6432	2433	1
7b787e6c1885dsf35	2022-03-11 13:42:13.0000000	1431	orq	YRT	6432	2433	1
7b787e6c1885dsf35	2022-03-11 13:42:28.0000000	419	orq	YRT	6432	2433	1
7b787e6c1885dsf35	2022-03-11 13:42:31.0000000	40	orq	YRT	6432	2433	1
7b787e6c1885dsf35	2022-03-11 13:42:48.0000000	450	orq	YRT	6432	2433	1
7b787e6c1885dsf35	2022-03-11 13:42:50.0000000	1435	orq	YRT	6432	2433	1
7b787e6c1885dsf35	2022-03-11 16:42:50.0000000	587	orq	YRT	6432	5342	1