/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

8 votes130 views2 answers
Pandas append csv file
Python
13 votes111 views3 answers
Pandas reset index start from 0
Python
13 votes118 views5 answers
Python get filename without extension
Python
13 votes115 views3 answers
List remove method in python
Python
0 vote121 views1 answer
Percentage of null values for every variable in dataframe
Python
2 votes102 views2 answers
Python convert datetime to float
Python
2 votes115 views2 answers
Requests sessions
Python
11 votes129 views4 answers
Add conda env to jupyter
Python
1 vote108 views1 answer
Python get latest edited file from any directory
Python
0 vote116 views1 answer
Make beep python
Python