/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

5 votes145 views2 answers
Python pie chart
Python
1 vote137 views1 answer
Db_index django
Python
0 vote148 views1 answer
Apyori
Python
0 vote126 views1 answer
Scroll horizontal excel
Python
0 vote145 views2 answers
Tkinter window - Source: NAYCode.com
Python
-1 vote116 views1 answer
How to ask a yes or no question on python
Python
3 votes126 views1 answer
Rotate picture in opencv2 python
Python
3 votes86 views2 answers
Python functional foreach
Python
0 vote117 views1 answer
Python youtube_dl custom path
Python
0 vote128 views1 answer
Pandas look for values in column with condition
Python