/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

5 votes183 views4 answers
Xticks and yticks matplotlib
Python
0 vote116 views1 answer
Python default parameters depend on other paramters
Python
0 vote130 views1 answer
Exercices pyton
Python
0 vote122 views2 answers
Plt.text background alpha
Python
6 votes104 views2 answers
Python max
Python
5 votes148 views3 answers
Render to response django
Python
0 vote128 views1 answer
Serversocket.accept() python
Python
23 votes115 views4 answers
Tkinter background color
Python
2 votes158 views2 answers
How to check django rest framework version
Python Django
3 votes135 views2 answers
Taking multiple input in python
Python