Currently I have several tables with 100k rows. I am trying to find the following data.
SELECT
* , SQRT(POW(69.1 * (latitude-‘49.1044302’), 2) + POW(69.1 * (‘-122.801094’-longitude) * COS(lat
Currently I have several tables with 100k rows. I am trying to find the following data.
SELECT
* , SQRT(POW(69.1 * (latitude-‘49.1044302’), 2) + POW(69.1 * (‘-122.801094’-longitude) * COS(lat