By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table search_results (original_id int, created date);
insert into search_results values
(1,'2024-01-01'),
(2,'2024-05-01'),
(3,'2024-03-01');
Records: 3 Duplicates: 0 Warnings: 0
SELECT
original_id, created
FROM search_results
ORDER BY original_id DESC
LIMIT 1;
| original_id | created |
|---|---|
| 3 | 2024-03-01 |
SELECT
original_id, created
FROM search_results
WHERE
original_id = (SELECT MAX(original_id) FROM search_results);
| original_id | created |
|---|---|
| 3 | 2024-03-01 |