/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

22 votes251 views6 answers
How to use dictionary in python
Python
2 votes230 views2 answers
Horizontal bar plot python
Python
14 votes267 views4 answers
Reset index
Python
1 vote226 views1 answer
Object value python
Python
0 vote257 views1 answer
How to work with jupyterlab and conda environments
Python
5 votes232 views1 answer
How to delete na values in a dataframe
Python
27 votes240 views4 answers
Discord.py status
Python
2 votes245 views4 answers
Python hash
Python
8 votes223 views3 answers
Django sort queryset
Python
0 vote233 views1 answer
Python import from string name
Python