/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 vote157 views1 answer
Python split only last occurrence of a character
Python
39 votes146 views6 answers
Objects and classes in python
Python
0 vote191 views1 answer
Are there learning activities for django-debug-toolbar
Python Django
-1 vote147 views3 answers
List
Python
1 vote167 views1 answer
Import numpy illegal instruction (core dumped) jetson nano
Python
0 vote147 views1 answer
Deep clone 2d list python
Python
0 vote149 views1 answer
Python dataframe appendisnt showing
Python
0 vote159 views1 answer
Go to line in jetbrain
Python
1 vote179 views1 answer
Python program to find fibonacci series using function recursion loop
Python
2 votes139 views2 answers
Run python script every hour
Python