/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 vote204 views1 answer
Django filter word count greater than
Python
0 vote205 views1 answer
Convert string input into a nested tuple in python
Python
0 vote221 views1 answer
Difference between __gte and __lte in Django
Python
34 votes191 views6 answers
Python to exe converter online
Python
2 votes214 views1 answer
Distance matrix in python
Python
2 votes195 views4 answers
Pandas fillna with mode
Python
0 vote204 views1 answer
Python setuptools cythonize except one file
Python
5 votes181 views3 answers
Split a column into two columns pandas
Python
11 votes196 views3 answers
How to send a message in a specific channel discord.py
Python
0 vote195 views1 answer
Image from wikipedia module in python
Python