Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #Format : LIMIT s-1, t - (s - 1)
- SELECT ROUND(ABS(x1 - x2) + ABS(y1 - y2), 4)
- FROM (SELECT MIN(lon) x1, MAX(lon) x2
- FROM (SELECT*FROM citytable
- WHERE lat < 121.8 ORDER BY lat DESC LIMIT 3, 15) AS Table1) AS latTable,
- (SELECT MIN(lat) y1, MAX(lat) y2
- FROM (SELECT*FROM citytable
- WHERE lon > 25.1 ORDER BY lon ASC LIMIT 3, 15) AS Table2) AS lonTable;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement