/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 vote292 views1 answer
Flask send email gmail
Python
1 vote285 views1 answer
Python region
Python
0 vote293 views1 answer
Radix sort in Python
Python
4 votes253 views5 answers
Python read xml
Python
0 vote268 views1 answer
Randomly pick a value in the list
Python
0 vote274 views2 answers
Python dict for k v
Python
0 vote320 views2 answers
How to JOIN three tables with Django ORM
Python
0 vote341 views1 answer
Extends template django file system
Python Django
53 votes291 views4 answers
Python get filename from path
Python
0 vote291 views2 answers
Seaborn distribution plot for all columns
Python