/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

1 vote185 views1 answer
Flask render error template
Python
0 vote187 views2 answers
Pandas groupby aggregate quantile
Python
1 vote186 views1 answer
Os.startfile
Python
0 vote189 views1 answer
How to use fastapi ApiClient with pytest
Python
0 vote186 views1 answer
Matplotlib don't use the alpha value of the plot in legend
Python
12 votes244 views3 answers
Iloc pandas
Python
12 votes180 views1 answer
Link shortener
Python
0 vote180 views1 answer
Accumulator programming python
Python
34 votes231 views6 answers
Round python
Python
1 vote203 views1 answer
How to check for duplicates in a column in python
Python