/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 vote189 views1 answer
What is append use
Python
0 vote158 views1 answer
Python console width
Python
4 votes152 views1 answer
7chats_np
Python
0 vote150 views1 answer
Pyqgis
Python
0 vote146 views1 answer
Pyton recognize any datetime format
Python
0 vote154 views1 answer
Sum of positive numbers in array with negative python
Python
13 votes166 views2 answers
How to flip a list backwards in python
Python
2 votes198 views3 answers
Standard deviation python
Python
27 votes188 views5 answers
Pretty json python
Python
34 votes136 views4 answers
Print Without Newline
Python