a guest Jul 7th, 2017 143 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- 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;
RAW Paste Data