/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

4 votes355 views3 answers
Python remove characters from end of string
Python
6 votes391 views3 answers
Flask cors
Python Flask
0 vote360 views1 answer
How to check if user pressed enter in python
Python
0 vote336 views1 answer
Python mongodump
Python
0 vote365 views1 answer
Render django views
Python
0 vote374 views1 answer
How to change scenes in python
Python
9 votes325 views3 answers
Python if elif
Python
24 votes366 views3 answers
Tkinter image
Python
0 vote329 views1 answer
How to print 2 list in python as table
Python
15 votes351 views6 answers
How to get confusion matrix in python
Python