/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 vote267 views1 answer
Celery timezone setting django
Python
0 vote280 views1 answer
I have two versions of python installed mac
Python
76 votes291 views6 answers
For loop in python
Python
0 vote262 views1 answer
{% load humanise %}
Python
3 votes249 views2 answers
Raising custom exception python
Python
2 votes264 views3 answers
Rotate matrix 90 degrees clockwise python
Python
3 votes247 views1 answer
Stripping /n in a readlines for a pytgon file
Python
1 vote339 views1 answer
Check if queryset is empty django template
Python Django
0 vote289 views1 answer
Query first 5 element in django
Python Django
0 vote247 views1 answer
Erase % sign in row pandas
Python