/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 vote113 views1 answer
Python seek file beginning after for line in file
Python
3 votes106 views1 answer
How to connect templates in django
Python
7 votes108 views3 answers
Python set cwd to file location
Python
18 votes108 views6 answers
Factorial python
Python
34 votes103 views6 answers
Name columns pandas
Python
0 vote54 views1 answer
How to django template character limit
Python
0 vote94 views1 answer
All objects and constants needed to use the ldap3 library can be imported from the ldap3 namespace
Python
-1 vote124 views2 answers
Django connection cursor
Python Django
0 vote114 views1 answer
Matplotlib boxplot remove outliers
Python
1 vote167 views1 answer
How to right click in pyautogui
Python