SQL Server 2022

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

Create Table table_name(_NAME VARCHAR(50), LINE INT, TIMESTAMP DATETIME, Equipment VARCHAR(50), CL_Name VARCHAR(50), Status INT, ROW_NUMBER INT);

Insert Into table_name Values('01Pack',2,'2023-01-04 16:45:35.673','Pack','A',0,288),
('01Pack',2,'2023-01-04 16:50:35.673','Pack','A',0,287),
('01Pack',2,'2023-01-04 16:55:35.673','Pack','A',0,286),
('02Pack',3,'2023-01-04 23:20:36.063','Pack','B',0,209),
('03Pack',4,'2023-01-04 23:20:36.063','Pack','C',0,209),
('03Pack',4,'2023-01-04 23:25:36.067','Pack','C',0,208),
('03Pack',4,'2023-01-04 23:30:36.073','Pack','C',0,207),
('03Pack',4,'2023-01-04 23:35:36.077','Pack','C',0,206),
('01Pack',2,'2023-01-04 23:45:36.067','Pack','A',0,206),
('01Pack',2,'2023-01-04 23:50:36.073','Pack','A',0,205),
('01Pack',2,'2023-01-04 23:55:36.077','Pack','A',0,204);
11 rows affected

Select Top 1 With Ties 
  _NAME, LINE, TIMESTAMP, Equipment, CL_Name, Status, [ROW_NUMBER]
From
(
  Select *,
    ROW_NUMBER() Over (Order By TIMESTAMP) -
    ROW_NUMBER() Over (Partition By _NAME Order By TIMESTAMP) As grp
  From table_name
) T
Order By ROW_NUMBER() Over (Partition By _NAME, grp Order By [ROW_NUMBER] Desc)


_NAME
LINE
TIMESTAMP
Equipment
CL_Name
Status
ROW_NUMBER


01Pack
2
2023-01-04 16:45:35.673
Pack
A
0
288

01Pack
2
2023-01-04 23:45:36.067
Pack
A
0
206

02Pack
3
2023-01-04 23:20:36.063
Pack
B
0
209

03Pack
4
2023-01-04 23:20:36.063
Pack
C
0
209


With create_groups AS
(
  Select *,
    ROW_NUMBER() Over (Order By TIMESTAMP) -
    ROW_NUMBER() Over (Partition By _NAME Order By TIMESTAMP) As grp
  From table_name
), 
max_row_num AS
(
  Select *,
    ROW_NUMBER() Over (Partition By _NAME, grp Order By [ROW_NUMBER] Desc) As rn
  From create_groups
)
Select _NAME, LINE, TIMESTAMP, Equipment, CL_Name, Status, [ROW_NUMBER]
From max_row_num
Where rn = 1
Order By _NAME, TIMESTAMP


_NAME
LINE
TIMESTAMP
Equipment
CL_Name
Status
ROW_NUMBER


01Pack
2
2023-01-04 16:45:35.673
Pack
A
0
288

01Pack
2
2023-01-04 23:45:36.067
Pack
A
0
206

02Pack
3
2023-01-04 23:20:36.063
Pack
B
0
209

03Pack
4
2023-01-04 23:20:36.063
Pack
C
0
209

_NAME	LINE	TIMESTAMP	Equipment	CL_Name	ROW_NUMBER
01Pack	2	2023-01-04 16:45:35.673	Pack	A	288
01Pack	2	2023-01-04 23:45:36.067	Pack	A	206
02Pack	3	2023-01-04 23:20:36.063	Pack	B	209
03Pack	4	2023-01-04 23:20:36.063	Pack	C	209