/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 vote240 views1 answer
Extends template django
Python Django
1 vote246 views1 answer
Python convert current datetime to rfc 1123 format
Python
1 vote219 views1 answer
How to open local html file in python
Python
0 vote246 views1 answer
Static instance and local variables in python
Python
0 vote254 views1 answer
Use colabs gpu locally
Python
0 vote270 views1 answer
What is a good django orm cookbook
Python Django
39 votes228 views6 answers
Remove spaces from string python
Python
-1 vote232 views1 answer
Flask run on ip and port
Python
1 vote213 views2 answers
Python long
Python
40 votes244 views6 answers
Pandas sort columns by name
Python