/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

2 votes219 views2 answers
Remove first item from list python
Python
0 vote210 views1 answer
Symbol to make things not equeal to something in python
Python
0 vote205 views1 answer
Do while python using dates
Python
0 vote254 views1 answer
Python - How to subtract values from dictionaries
Python
0 vote224 views1 answer
Remove element from pack tkinter
Python
0 vote215 views1 answer
Python collections to dictionary
Python
0 vote174 views1 answer
Give colour to the font in python email message
Python
7 votes229 views5 answers
Unnamed 0 pandas
Python
2 votes142 views1 answer
Executing shell commands in python
Python
0 vote181 views1 answer
Python check if image is corrupted
Python