/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 votes329 views2 answers
Sha512 python
Python
0 vote311 views2 answers
Terneray operator in python
Python
0 vote306 views1 answer
Concatenate directories python
Python
0 vote342 views1 answer
Calculate quartil python
Python
5 votes342 views2 answers
Read matlab file in python
Python
0 vote348 views1 answer
Python yield from
Python
0 vote326 views1 answer
How to put words into list
Python
1 vote381 views2 answers
Run flask in background
Python Flask
39 votes337 views5 answers
Csv to python
Python
0 vote336 views1 answer
Check if string contains alphabets python
Python