/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

0 vote201 views1 answer
Get the time of 1 minute later in python
Python
0 vote191 views1 answer
Pyqt button clicked connect
Python
1 vote191 views1 answer
Emacs region indent python
Python
0 vote193 views1 answer
How to end an infinite loop in specific time python
Python
3 votes189 views1 answer
Python run a system command
Python
0 vote207 views1 answer
Pyplot define plotsize
Python
0 vote208 views2 answers
Create column with values mapped from another column python
Python
3 votes197 views1 answer
How does scope work in python
Python
0 vote203 views1 answer
Get list of users django
Python Django
120 votes197 views6 answers
Getting Input in Python
Python