/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

0 vote279 views1 answer
Numpy sort multidimensional array
Python
5 votes320 views2 answers
Python how to put int into list
Python
0 vote310 views1 answer
Install easygui
Python
10 votes331 views2 answers
With open as file python
Python
2 votes345 views3 answers
Rotate matrix 90 degrees clockwise python
Python
16 votes306 views4 answers
How to reverse array in python
Python
0 vote367 views1 answer
Django admin no such table user
Python Django
0 vote263 views1 answer
Select Children of an Object With ForeignKey in Django?
Python
0 vote307 views1 answer
Print only strings in list python
Python
0 vote353 views1 answer
Tkinter titre fenetre
Python