/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 votes170 views3 answers
Message: 'chromedriver' executable needs to be in PATH. Please see https://sites.google.com/a/chromium.org/chromedriver/home
Python
1 vote137 views1 answer
User matching query does not exist. django
Python
0 vote133 views1 answer
Discord.py autorole
Python
0 vote134 views1 answer
Heatmap choos format for annotation
Python
25 votes136 views10 answers
Github
Python
0 vote154 views1 answer
Gogle query python simple
Python
2 votes139 views1 answer
How do I mock an uploaded file in django?
Python
0 vote159 views1 answer
"api_view" is not defined django
Python Django
0 vote132 views1 answer
How to update sheety
Python
20 votes134 views6 answers
Drop a column from dataframe
Python