/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 vote233 views1 answer
Django get form data from post
Python
2 votes246 views1 answer
Dataframe get list of index vlaues
Python
21 votes246 views7 answers
Pyinstaller
Python
5 votes229 views1 answer
Python matplt
Python
0 vote251 views1 answer
Get more than one decimal in python
Python
0 vote256 views1 answer
Python replace list from another dictionary items
Python
0 vote244 views2 answers
Doing math in python
Python
0 vote267 views1 answer
Else statement python list comprehension
Python
0 vote244 views1 answer
Python use getcontext
Python
2 votes295 views1 answer
Django template tag to display current year
Python Django