/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

8 votes158 views2 answers
Syntaxerror: eol while scanning string literal
Python
1 vote171 views6 answers
Insertion sort
Python
2 votes163 views1 answer
Scikit learn decision tree12
Python
19 votes168 views1 answer
Python cut string to length
Python
0 vote172 views1 answer
How to add legend on side of the chart python
Python
0 vote176 views1 answer
Seaborn define linewidth
Python
0 vote185 views1 answer
Make blinking text python1
Python
6 votes156 views2 answers
Python gzip a file
Python
3 votes175 views4 answers
How to get dictionary input from user in python
Python
8 votes172 views3 answers
Isnumeric python
Python