By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE people (
id int,
person_id int,
meeting_time int
);
insert into people values
(1, 21, 123456),
(2, 21, 123457),
(3, 21, 123456),
(4, 22, 123470),
(5, 21, 0);
Records: 5 Duplicates: 0 Warnings: 0
select *
from people;
| id | person_id | meeting_time |
|---|---|---|
| 1 | 21 | 123456 |
| 2 | 21 | 123457 |
| 3 | 21 | 123456 |
| 4 | 22 | 123470 |
| 5 | 21 | 0 |
select p.*
from people p
inner join (
SELECT person_id, max(id) as id
FROM people
WHERE meeting_time between 123451 and 123460
group by person_id
) as s on s.id = p.id
| id | person_id | meeting_time |
|---|---|---|
| 3 | 21 | 123456 |