/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 vote201 views1 answer
Pil
Python
0 vote289 views1 answer
He escape() function is used to convert the <, &, and > characters to the corresponding entity references:
Python
0 vote219 views1 answer
Shuffle text lines python
Python
0 vote199 views1 answer
Tuples unpacking
Python
92 votes199 views6 answers
String to datetime
Python
29 votes209 views6 answers
Install python ubuntu
Python
4 votes200 views2 answers
Hpw tp install discord.py
Python
-1 vote202 views1 answer
Percentage plot of categorical variable in python woth hue
Python
0 vote202 views1 answer
Initiate dask
Python
7 votes235 views2 answers
Pandas profile
Python