/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

1 vote118 views1 answer
Np.rand.randint
Python
17 votes114 views2 answers
Discord bot status python
Python
2 votes114 views1 answer
Google scikit learn decision tree
Python
0 vote116 views1 answer
Print in binary python
Python
212 votes309 views6 answers
Generate random number python
Python
1 vote106 views1 answer
What is kali
Python
2 votes100 views1 answer
Test_size
Python
0 vote122 views1 answer
Cuantas palabras hay en una frase en python
Python
0 vote201 views1 answer
Tryexept in python
Python
20 votes123 views3 answers
How to convert all items in a list to integer python
Python