/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 vote359 views1 answer
Pygame pin to top
Python
0 vote332 views1 answer
Get value of bit in integer python
Python
0 vote371 views1 answer
Django rest DjangoModelPermissions include get
Python Django
5 votes357 views3 answers
Concatenate two tensors pytorch
Python
0 vote385 views1 answer
Shebang line python
Python
13 votes351 views2 answers
Pip version command
Python
25 votes370 views2 answers
Python slit
Python
22 votes370 views3 answers
Python sort list in reverse order
Python
0 vote360 views1 answer
Creer des disques en python tkinter
Python
0 vote313 views1 answer
How to read unicode in python
Python