/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 vote168 views1 answer
Remove emoji
Python
1 vote170 views1 answer
Types of dict comprehension
Python
0 vote175 views1 answer
Ejercicios con def en python
Python
0 vote184 views1 answer
Bolumden kalan python
Python
-1 vote164 views1 answer
Turtle write function in turtle package python
Python
8 votes173 views3 answers
How to maximize pandas output python
Python
0 vote310 views1 answer
Python use math
Python
0 vote215 views1 answer
Creating base models django
Python Django
1 vote174 views1 answer
Can list comprehenios contain else
Python
13 votes193 views2 answers
Wap in python to check a number is odd or even
Python