/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 vote162 views1 answer
Get time between things python
Python
0 vote186 views1 answer
How to draw squircle python
Python
0 vote163 views1 answer
How to check for non-datetime value in python
Python
26 votes182 views6 answers
Python remove whitespace from start of string
Python
1 vote159 views1 answer
>>> import numpy Illegal instruction (core dumped)
Python
0 vote184 views1 answer
Python logger printing multiple times
Python
2 votes159 views1 answer
Os.getlogin() python
Python
0 vote153 views1 answer
How to get python to write to 100
Python
0 vote184 views1 answer
Destructuring in for loops python
Python
0 vote167 views1 answer
How to insert files in tuple python
Python