/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 vote133 views1 answer
Python convert querydict to dict
Python
8 votes119 views3 answers
Python utf8
Python
0 vote147 views1 answer
Ist comperension python
Python
0 vote139 views1 answer
Natsort python pip install
Python
0 vote129 views1 answer
Name decorator in python
Python
5 votes144 views1 answer
Purge python version ubuntu
Python
21 votes149 views4 answers
Get list input from user in python
Python
0 vote181 views1 answer
Jupyter upload folder
Python
0 vote131 views1 answer
Check if argv exists python
Python
2 votes154 views1 answer
Django models distinct
Python Django