DefconOne

yp.da.pr.7-1-13

Sep 19th, 2022
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT DISTINCT u.id,
  2.        (MIN(p.creation_date) OVER (PARTITION BY u.id)) - u.creation_date delta
  3. FROM stackoverflow.posts p
  4. JOIN stackoverflow.users u ON p.user_id = u.id;
Advertisement
Add Comment
Please, Sign In to add comment