/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 vote167 views2 answers
Flask return html
Python
14 votes172 views6 answers
Binary search in python
Python
0 vote167 views1 answer
Resize a Turtle object
Python
3 votes167 views2 answers
Numpy array sorting
Python
0 vote172 views1 answer
Calculate the euler totient of a number python
Python
10 votes177 views3 answers
Python click on screen
Python
1 vote171 views1 answer
Python npr permutation calculation
Python
2 votes181 views1 answer
No module named 'libtorrent'
Python
0 vote197 views1 answer
Python 3.7 centos in _run_pip import pip._internal zipimport.ZipImportError: can't decompress data; zlib not available make: *** [altinstall] Error 1
Python
1 vote186 views1 answer
How to hide axis in matplotlib
Python