Advertisement
Guest User

Untitled

a guest
May 3rd, 2016
41
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. select tt.id, abs(t1.len-t2.len) df
  2. from
  3. (select id, min(Num_challenge) min_nc, max(Num_challenge) max_nc
  4. from t group by id) tt
  5. join t t1 on t1.id=tt.id and t1.Num_challenge=tt.min_nc
  6. join t t2 on t2.id=tt.id and t2.Num_challenge=tt.max_nc
  7. order by df desc
  8. limit 3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement