/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 vote231 views2 answers
How to print 0 to 10 in python
Python
0 vote194 views1 answer
Python second interval
Python
0 vote212 views1 answer
Create file and store output python
Python
0 vote191 views3 answers
Python multiplication table while loop
Python
1 vote182 views1 answer
Get csrf_token value in django template
Python
0 vote201 views1 answer
Create chatbot in Python - Source: NAYCode.com
Python
0 vote221 views1 answer
Matplotlib force scientific notation and define exponent
Python
3 votes204 views1 answer
Django session expire time
Python
1 vote215 views2 answers
Python how to print variable value
Python
7 votes184 views2 answers
Python duplicate file
Python