/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 votes217 views2 answers
Moving average numpy
Python
0 vote219 views1 answer
Connect mysql sql alchemy
Python
1 vote210 views1 answer
How to obtain the content of brackets
Python
0 vote200 views1 answer
Half String
Python
0 vote225 views1 answer
Replace NaN value in pandas data frame with zeros
Python
1 vote228 views2 answers
Explode multiple columns pandas
Python
3 votes206 views4 answers
Tkinter maximize window
Python
0 vote241 views1 answer
Change marker border color plotly
Python
1 vote192 views1 answer
Python tipi array
Python
0 vote222 views1 answer
Replace nat with date pandas
Python