/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

12 votes166 views6 answers
Python check if nan
Python
1 vote126 views1 answer
Create a response object python
Python
1 vote174 views1 answer
Remove minimize and maximize and cancle button python pyqt5
Python
1 vote185 views1 answer
Python random.choices vs random.sample
Python
0 vote189 views1 answer
Flask multuple parameters
Python Flask
0 vote191 views1 answer
List comprehensions with dates
Python
9 votes185 views2 answers
Django app
Python Django
0 vote165 views1 answer
Exec to return a value python
Python
11 votes189 views4 answers
Python remove empty values from list
Python
54 votes156 views2 answers
How to run django requirement.txt
Python