/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

2 votes303 views2 answers
Search in django
Python
0 vote274 views4 answers
How to show variable in Jupyter
Python
1 vote292 views1 answer
Cmd to get ip address python
Python
0 vote299 views1 answer
Python create a pinging sound
Python
0 vote293 views1 answer
Dt.weekday_name
Python
0 vote311 views1 answer
Code folding vim python
Python
0 vote302 views1 answer
Python drop rows with two conditions
Python
0 vote344 views1 answer
Permission denied when converting dataframe to csv
Python
0 vote291 views2 answers
I want to get only first record of each user in pandas
Python
17 votes300 views3 answers
Python get current file location
Python