/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

6 votes312 views3 answers
Flask client ip
Python Flask
0 vote264 views1 answer
Access host database django docker
Python
1 vote261 views1 answer
Pandas python group by for one column and sum another column
Python
9 votes287 views2 answers
Make string numeric pandas
Python
0 vote373 views2 answers
Spacy french stopwords
Python
0 vote274 views1 answer
Proper pagination django template
Python
-2 votes302 views1 answer
Python merge list no duplicates
Python
85 votes281 views6 answers
How to create virtual environment
Python
25 votes268 views6 answers
Python remove spaces
Python
0 vote299 views1 answer
Conda install pypy
Python