MySQL 8.0

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

CREATE TABLE tbl (
  `ID` INT,
  `group` VARCHAR(50),
  `timestamp` timestamp
);

INSERT INTO tbl VALUES
  ('001', 'AA', '2021-03-23 22:48:34.879'),
  ('002', 'XT', '2021-03-24 01:18:34.879'),
  ('002', 'BB', '2021-03-25 22:42:34.879'),
  ('003', 'SW', '2021-03-25 12:53:34.879'),
  ('003', 'Fe', '2021-03-25 14:37:34.879'),
  ('003', 'AA', '2021-03-25 13:26:34.879');

Records: 6  Duplicates: 0  Warnings: 0


SELECT A.* 
FROM tbl A JOIN
(SELECT ID, MIN(TIMESTAMP) as last_time /*maybe MAX(timestamp)?*/
FROM tbl
GROUP BY ID) B
ON A.ID=B.ID AND A.timestamp=B.last_time ;


ID
group
timestamp


1
AA
2021-03-23 22:48:35

2
XT
2021-03-24 01:18:35

3
SW
2021-03-25 12:53:35


SELECT A.* 
FROM tbl A JOIN
(SELECT ID, MAX(TIMESTAMP) as last_time
FROM tbl
GROUP BY ID) B
ON A.ID=B.ID AND A.timestamp=B.last_time ;


ID
group
timestamp


1
AA
2021-03-23 22:48:35

2
BB
2021-03-25 22:42:35

3
Fe
2021-03-25 14:37:35

ID	group	timestamp
1	AA	2021-03-23 22:48:35
2	XT	2021-03-24 01:18:35
3	SW	2021-03-25 12:53:35

ID	group	timestamp
1	AA	2021-03-23 22:48:35
2	BB	2021-03-25 22:42:35
3	Fe	2021-03-25 14:37:35