/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 vote269 views1 answer
Day 14 scope hackerrank solution in python
Python
0 vote281 views2 answers
Jsonresponse status code django
Python Django
0 vote265 views1 answer
Python cartesian coordinates code
Python
2 votes300 views2 answers
Print labels on confusion_matrix
Python
1 vote258 views1 answer
How to get pygame key
Python
0 vote269 views1 answer
How to run multiple python files one after another
Python
66 votes296 views4 answers
Iterate over rows dataframe
Python
0 vote291 views1 answer
Pandas drop 1970
Python
0 vote279 views1 answer
Natsort python pip install
Python
0 vote325 views1 answer
Recall calculate confusion matrix .ravel()
Python