Breaking News: Grepper is joining You.com. Read the official announcement!

order records between two cordinates sql

Said HR answered on February 22, 2022 Popularity 1/10 Helpfulness 1/10

answer order records between two cordinates sql

order records between two cordinates sql

Comment

SELECT 
id, 
(
   3959 *
   acos(cos(radians(37)) * 
   cos(radians(lat)) * 
   cos(radians(lng) - 
   radians(-122)) + 
   sin(radians(37)) * 
   sin(radians(lat )))
) AS distance 
FROM markers 
HAVING distance < 29 and distance > 28 
ORDER BY distance LIMIT 0, 20;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: between records sql

Link to this answer
Share Copy Link