/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

3 votes254 views1 answer
Pandas load txt database
Python
1 vote170 views2 answers
How to convert datetime to integer in python
Python
0 vote200 views1 answer
Python - Cómo comprobar si dos cuerdas son anagramas
Python
0 vote258 views1 answer
Num=operator.index(num) name 'num' is not defined
Python
1 vote277 views1 answer
Django get part of queryset
Python Django
0 vote179 views1 answer
Python playsound stop
Python
22 votes211 views6 answers
How to use dictionary in python
Python
0 vote196 views1 answer
Write a Python program to get the Fibonacci series between 0 to 50. Note : The Fibonacci Sequence is the series of numbers
Python
0 vote150 views1 answer
Update cell in sheet by column name using pandas
Python
84 votes191 views6 answers
How to sort in pandas
Python