SELECT ( 3959 * acos( cos( radians(28.6219459) ) * cos( radians( Latitude ) ) *
cos( radians( Longitude ) - radians(77.384108) ) + sin( radians(28.6219459) ) *
sin( radians( Latitude ) ) ) ) AS distance,DealerName,DealerID
FROM jcb.tbl_dealer_list HAVING distance < 10 ORDER BY distance LIMIT 0 , 20;
No comments:
Post a Comment