how do i join two rows on the same table based on the same timestamp?

assuming you only ever have one record per timestamp with a non-null value in a specific column, try this:

SELECT to_timestamp, MAX(str_v), MAX(long_v)
FROM table
GROUP BY to_timestamp;

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top