----基準の緯度経度
WITH
wk_point(baseLATITUDE, baseLONGITUDE)
AS
 (
 SELECT
  LATITUDE
  ,LONGITUDE
 FROM
  LOCATION_TBL
 WHERE
  DISTRICT_CODE = '1101'
 )
,
----各地点との距離
--WITH
wk_dis(wkDISTRICT_CODE, wkDIS)
AS
 (
 SELECT
  DISTRICT_CODE
  ,(POW((baseLATITUDE - LATITUDE),2) + POW((baseLONGITUDE - LONGITUDE),2)) as DIS
 FROM
  LOCATION_TBL
  CROSS JOIN wk_point
 WHERE
  DISTRICT_CODE <> '1101'
 )
---表示
SELECT
 LT.DISTRICT_CODE as CODE
 ,DISTRICT_NAME as NAME
 ,LATITUDE as LAT
 ,LONGITUDE as LON
FROM
 LOCATION_TBL as LT
 INNER JOIN DISTRICT as IJ
 on LT.DISTRICT_CODE = IJ.DISTRICT_CODE
 INNER JOIN wk_dis as wd
 on LT.DISTRICT_CODE = wd.wkDISTRICT_CODE
WHERE
 LT.DISTRICT_CODE <> '1101'
 and IJ.DISTRICT_CODE <> '1101'
ORDER BY
 wkDIS desc
 ,LT.DISTRICT_CODE