MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE data (id INT, `time` INT);
INSERT INTO data VALUES
(1,1), (1,3), (1,5),
(2,5), (2,3), (2,1),
(4,1), (4,5), (4,3),
(5,3), (5,1), (5,5),
(6,1), (6,3), (6,5);
SELECT * FROM data;


id
time


1
1

1
3

1
5

2
5

2
3

2
1

4
1

4
5

4
3

5
3

5
1

5
5

6
1

6
3

6
5


SELECT * FROM `data` where `id`=1 ORDER by time DESC limit 1;
SELECT * FROM `data` where `id`=2 ORDER by time DESC limit 1;
SELECT * FROM `data` where `id`=3 ORDER by time DESC limit 1;
SELECT * FROM `data` where `id`=4 ORDER by time DESC limit 1;
SELECT * FROM `data` where `id`=5 ORDER by time DESC limit 1;


id
time


1
5




id
time


2
5




id
time


4
5




id
time


5
5


WITH cte AS ( SELECT *, ROW_NUMBER() OVER (PARTITION BY id ORDER BY `time` DESC) rn
              FROM data
              WHERE id BETWEEN 1 AND 5 )
SELECT * 
FROM cte
WHERE rn = 1;


id
time
rn


1
5
1

2
5
1

4
5
1

5
5
1