Postgres 14

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

CREATE TABLE tbl (id int, name text, salary numeric, birthdate date, last_update timestamp);
    
INSERT INTO tbl VALUES
  (0, 'Third Guy'   , 666        , '2004-08-03', '2022-01-04 11:26:00')  -- added to work out diff
, (1, 'Ann Alden'   , 123000.00  , '1986-03-04', '2022-01-04 11:30:30')
, (3, 'Chloe Cat'   , 99999999.99, '1999-01-15', '2022-01-04 12:25:45')
, (4, 'Don Denton'  , 91234.24   , '2004-08-03', '2022-01-04 12:45:00')
, (5, 'Eddy Edwards', 55125125.25, '2003-05-17', '2022-01-05 23:00:00')
;
5 rows affected

-- Get only consecutive pairs:
SELECT (t1).*, (t2).*
FROM  (
   SELECT t AS t1, lead(t) OVER (ORDER BY last_update, id) AS t2
   FROM   tbl AS t
   ) sub
WHERE  (t1).last_update > (t2).last_update - interval '1 hour';


id
name
salary
birthdate
last_update
id
name
salary
birthdate
last_update


0
Third Guy
666
2004-08-03
2022-01-04 11:26:00
1
Ann Alden
123000.00
1986-03-04
2022-01-04 11:30:30

1
Ann Alden
123000.00
1986-03-04
2022-01-04 11:30:30
3
Chloe Cat
99999999.99
1999-01-15
2022-01-04 12:25:45

3
Chloe Cat
99999999.99
1999-01-15
2022-01-04 12:25:45
4
Don Denton
91234.24
2004-08-03
2022-01-04 12:45:00


-- Get *all* pairs:
SELECT *
FROM   tbl t1
JOIN   tbl t2 ON t1.last_update < t2.last_update
             AND t1.last_update > t2.last_update - interval '1 hour';


id
name
salary
birthdate
last_update
id
name
salary
birthdate
last_update


0
Third Guy
666
2004-08-03
2022-01-04 11:26:00
1
Ann Alden
123000.00
1986-03-04
2022-01-04 11:30:30

0
Third Guy
666
2004-08-03
2022-01-04 11:26:00
3
Chloe Cat
99999999.99
1999-01-15
2022-01-04 12:25:45

1
Ann Alden
123000.00
1986-03-04
2022-01-04 11:30:30
3
Chloe Cat
99999999.99
1999-01-15
2022-01-04 12:25:45

3
Chloe Cat
99999999.99
1999-01-15
2022-01-04 12:25:45
4
Don Denton
91234.24
2004-08-03
2022-01-04 12:45:00

id	name	salary	birthdate	last_update	id	name	salary	birthdate	last_update
0	Third Guy	666	2004-08-03	2022-01-04 11:26:00	1	Ann Alden	123000.00	1986-03-04	2022-01-04 11:30:30
1	Ann Alden	123000.00	1986-03-04	2022-01-04 11:30:30	3	Chloe Cat	99999999.99	1999-01-15	2022-01-04 12:25:45
3	Chloe Cat	99999999.99	1999-01-15	2022-01-04 12:25:45	4	Don Denton	91234.24	2004-08-03	2022-01-04 12:45:00