Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- sum(
- abs(i1.time1 - i1.time2)
- - (if (i1.time2 < i2.time1, 0,
- (if (i1.time1 < i2.time1 AND i1.time2 > i2.time2, abs(i2.time1 - i2.time2),
- if (i1.time1 < i2.time1 AND i1.time2 < i2.time2, abs(i1.time2 - i2.time1), 0))
- )
- ))
- )
- from mytable i1 join mytable i2 limit 1000;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement