Advertisement
Guest User

Untitled

a guest
Oct 20th, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. SELECT libname, city, 2 * 3961 * ASIN(SQRT((SIN(RADIANS((lat - 40.113799) / 2))) ^ 2 + COS(RADIANS(40.113799)) * COS(RADIANS(lat)) * (SIN(RADIANS((lon - -88.225202) / 2))) ^ 2)) as distance
  2. FROM Charters
  3. ORDER BY distance ASC /* in miles */
  4. LIMIT 50
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement