/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 vote296 views1 answer
Unique_together what is used of it in django
Python Django
0 vote288 views1 answer
Escape sequence in python
Python
-1 vote291 views2 answers
Write a python program to multiplies all the items in a list.
Python
41 votes325 views6 answers
Pandas replace empty string with nan
Python
0 vote335 views1 answer
Matplotlib get padding from bbox
Python
0 vote339 views1 answer
Pycharm flask invalid or missing encoding declaration
Python Flask
66 votes361 views6 answers
Python virtual environment
Python
3 votes305 views3 answers
Pd.merge remove duplicate columns
Python
0 vote328 views1 answer
Settings.debug django
Python Django
1 vote282 views1 answer
Tqdm command that works both in notebook and lab
Python