SQL Server 2019

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

Drop Table Tbl
Msg 3701 Level 11 State 5 Line 1
Cannot drop the table 'Tbl', because it does not exist or you do not have permission.

Create Table Tbl (UserId Int, EventTime DateTime)
Insert Into Tbl (UserId, EventTime)
Values (1, '20211230 10:03:44.500'),
	   (1, '20211230 10:30:44.500'),
	   (1, '20211230 11:29:44.500'),
	   (1, '20211230 13:29:44.500'),
	   (2, '20211230 13:29:44.500'),
	   (2, '20211230 13:27:44.500'),
	   (2, '20211230 15:27:44.500'),
	   (2, '20211230 17:27:44.500'),
	   (2, '20211230 18:00:44.500')
9 rows affected

	With CTE As (
	Select USERID, EVENTTIME, Row_Number() Over (Order by USERID, EVENTTIME) As ID
	From Tbl
	)
	Select T.USERID, T.EVENTTIME
	From CTE As a Cross Apply (Select USERID, EVENTTIME 
							   From CTE 
							   Where Abs(datediff(minute, a.EVENTTIME, EVENTTIME))<=60
									 And USERID=a.USERID And ID<>a.ID) As T
	Group by T.USERID, T.EVENTTIME


USERID
EVENTTIME


1
2021-12-30 10:03:44.500

1
2021-12-30 10:30:44.500

1
2021-12-30 11:29:44.500

2
2021-12-30 13:27:44.500

2
2021-12-30 13:29:44.500

2
2021-12-30 17:27:44.500

2
2021-12-30 18:00:44.500

USERID	EVENTTIME
1	2021-12-30 10:03:44.500
1	2021-12-30 10:30:44.500
1	2021-12-30 11:29:44.500
2	2021-12-30 13:27:44.500
2	2021-12-30 13:29:44.500
2	2021-12-30 17:27:44.500
2	2021-12-30 18:00:44.500