/Python/SQL Query to Join Two Tables Based Off Closest Timestamp

SQL Query to Join Two Tables Based Off Closest Timestamp

SELECT case.id, case.resolution, case.timestamp, class.value
  FROM closed_cases AS case
  LEFT JOIN (select c.*, 
                    (select min(timestamp)
                     from classifications c1
                      where c1.timestamp > c.timestamp) timeend
             from classifications c) AS class 
  ON case.timestamp >= class.timestamp and 
     (case.timestamp < class.timeend or class.timeend IS NULL)
  WHERE case.timestamp BETWEEN $1 AND $2;

Source: stackoverflow.com

Similar codes

31 votes333 views6 answers
Try except python
Python
0 vote545 views1 answer
Pycharm display info of function
Python
0 vote320 views1 answer
Aggregate on the entire DataFrame without group
Python
1 vote340 views1 answer
Insert missing data in pandas
Python
2 votes329 views1 answer
Tensorflow for python 3.9
Python
1 vote311 views1 answer
Python ctypes get current window
Python
6 votes350 views4 answers
Python Day of the week
Python
12 votes329 views5 answers
Conda python update
Python
23 votes331 views4 answers
Django runserver
Python
3 votes340 views1 answer
Python nmap
Python