/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

36 votes152 views6 answers
Python pandas
Python
4 votes159 views2 answers
How to concat on the basis of particular columns in pandas
Python
0 vote154 views1 answer
Shutdown flask server with request
Python
0 vote263 views1 answer
Python3 print format float
Python
60 votes155 views4 answers
Python choose random sample from list
Python
9 votes167 views1 answer
Except as Exception:
Python
1 vote147 views1 answer
AttributeError: 'NoneType' object has no attribute 'initialize_on_transport'
Python
0 vote102 views2 answers
Numerical laplace in python
Python
39 votes155 views5 answers
Round off to two decimal places python
Python
0 vote202 views1 answer
Adding extra fields to user model django
Python Django