Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. SELECT e.start_time, ne.start_time, e.end_time
  2. FROM
  3. (SELECT e.ID, e.start_time, e.end_time, ROW_NUMBER() OVER (PARTITION BY e.ID ORDER BY e.start_time) AS "SEQ"
  4. FROM events e
  5. )e
  6. LEFT JOIN
  7. (SELECT ne.ID, ne.start_time, ne.end_time, ROW_NUMBER() OVER (PARTITION BY ne.ID ORDER BY ne.start_time) AS "nSEQ"
  8. FROM events ne
  9. )ne
  10. ON e.ID = ne.ID
  11. AND e.SEQ = ne.nSEQ - 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement