Contoh query : dimana Latitude = -6.827920461143512 Longitude = 107.4349594116211 SELECT name,latitude,longitude ,111.045* DEGREES(ACOS(COS(RADIANS(-6.827920461143512)) * COS(RADIANS(latitude )) * COS(RADIANS(107.4349594116211) - RADIANS( longitude )) + SIN(RADIANS(-6.827920461143512)) * SIN(RADIANS( latitude ) ))) AS distance_in_km from services ORDER BY distance_in_km asc; hasil Sumber referensi https://medium.com/@emild/sql-server-query-untuk-sorting-jarak-berdasarkan-lokasi-3bd6bcfc1aeb