Breaking News: Grepper is joining You.com. Read the official announcement!

SQL Query to Join Two Tables Based Off Closest Timestamp

Clumsy Cowfish answered on August 3, 2021 Popularity 2/10 Helpfulness 8/10

answer SQL Query to Join Two Tables Based Off Closest Timestamp

SQL Query to Join Two Tables Based Off Closest Timestamp

Comment

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;

Popularity 2/10 Helpfulness 8/10 Language python

Source: stackoverflow.com

Tags: closest join python sql timestamp

Link to this answer
Share Copy Link