/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 vote423 views1 answer
Map function to change type of element in python
Python
0 vote205 views1 answer
List alpha numeric
Python
25 votes437 views3 answers
Startapp django
Python Django
0 vote219 views1 answer
How to store a int value in django sessions
Python
1 vote212 views1 answer
Olst = [] a = int(input()) b = int(input()) for ele in range(a,b+1): if ele%2 != 0: olst.append(ele) print(olst[::-1])
Python
1 vote209 views1 answer
Python singleton
Python
1 vote150 views1 answer
Print last output python
Python
0 vote215 views1 answer
End of statement expected python
Python
0 vote208 views1 answer
Python requests insecure request warning
Python
0 vote181 views1 answer
Pandas previous row
Python