MySQL 8.0

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

CREATE TABLE mytable( 
 ID INT, 
 random_string VARCHAR(255), 
 time TIMESTAMP);

INSERT INTO mytable VALUES 
(2 , 'K2K3KD9AJ  ', '2022-07-21 20:41:15'),
(1 , 'SJQJ8JD0W  ', '2022-07-17 23:46:13'),
(1 , 'JSDOAJD8   ', '2022-07-11 02:52:21'),
(3 , 'KPWJOFPSS  ', '2022-07-11 02:51:57'),
(1 , 'DA8HWD8HHD ', '2022-07-11 02:51:49');
SELECT m1.ID,
       m1.random_string,
       m1.time
FROM mytable m1
WHERE EXISTS
  (SELECT ID
    FROM mytable AS m2
    GROUP BY ID
    HAVING m1.ID=m2.ID 
      AND m1.time= MAX(time)
          )


ID
random_string
time


2
K2K3KD9AJ
2022-07-21 20:41:15

1
SJQJ8JD0W
2022-07-17 23:46:13

3
KPWJOFPSS
2022-07-11 02:51:57


SELECT m1.ID,
       m1.random_string,
       m1.time
FROM mytable m1
JOIN
  (SELECT ID,  MAX(time) AS mxtime
    FROM mytable 
    GROUP BY ID) AS m2
 ON m1.ID=m2.ID
   AND m1.time=m2.mxtime


ID
random_string
time


2
K2K3KD9AJ
2022-07-21 20:41:15

1
SJQJ8JD0W
2022-07-17 23:46:13

3
KPWJOFPSS
2022-07-11 02:51:57

ID	random_string	time
2	K2K3KD9AJ	2022-07-21 20:41:15
1	SJQJ8JD0W	2022-07-17 23:46:13
3	KPWJOFPSS	2022-07-11 02:51:57