/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 vote151 views1 answer
Create a queryset list django
Python Django
29 votes160 views5 answers
Python date and time
Python
0 vote166 views1 answer
Pandas show full columns
Python
0 vote162 views1 answer
If statement collection python
Python
17 votes174 views3 answers
Set title matplotlib
Python
4 votes152 views2 answers
Python join array of ints
Python
1 vote150 views1 answer
Variable plus one python
Python
26 votes207 views2 answers
For row in column pandas
Python
1 vote170 views1 answer
Python sympy solve equation equal to 0
Python
1 vote280 views1 answer
How to right click in pyautogui
Python