/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 vote141 views1 answer
Python convert current datetime to rfc 1123 format
Python
0 vote161 views1 answer
Django ninja "schema"
Python Django
13 votes132 views1 answer
Configure funCtion in tkinter
Python
0 vote142 views1 answer
Crank nicholson scheme python
Python
3 votes132 views6 answers
Django login
Python
0 vote115 views1 answer
Python function returning dictonary
Python
0 vote165 views1 answer
Parser.add_argument array python
Python
0 vote81 views1 answer
Django include all columns admin show
Python
2 votes128 views3 answers
How to check current version of tensorflow
Python
0 vote120 views1 answer
Plt.tick_params
Python