/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

1 vote136 views1 answer
Python nCr n choose r function
Python
12 votes223 views5 answers
Merge two dataframes based on column
Python
12 votes141 views2 answers
How to shutdown a windows 10 computer using python
Python
-1 vote196 views1 answer
Sort pandas dataframe by specific column
Python
-1 vote161 views1 answer
Phyton datetime comparison
Python
0 vote192 views1 answer
Perform a right outer join of self and other.
Python
0 vote167 views1 answer
How to make a python file that prints out a random element from a list
Python
4 votes141 views2 answers
Pyautogui.click
Python
4 votes154 views2 answers
Queue python
Python
0 vote138 views1 answer
Using csv module how to read perticular lines in csv
Python