/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 vote282 views1 answer
Tkinter button position
Python
1 vote312 views1 answer
Remove consecutive duplicates python
Python
14 votes339 views5 answers
Discord py get user by id
Python
13 votes315 views2 answers
Python programming online editor
Python
2 votes325 views3 answers
WARNING: pip is configured with locations that require TLS/SSL, however the ssl module in Python is not available. buildozer
Python
0 vote316 views1 answer
Python break list into n lists
Python
4 votes327 views1 answer
Circle python programe
Python
0 vote318 views1 answer
Rendere eseguibile python
Python
1 vote316 views1 answer
Split list into list of lists python on every n element
Python
0 vote311 views1 answer
Python counting up and down
Python