WITH A AS(
SELECT *,LATITUDE AS LA,LONGITUDE AS LO
FROM LOCATION_TBL
WHERE DISTRICT_CODE	= '1101'),

B AS(
SELECT L.DISTRICT_CODE,L.LATITUDE,L.LONGITUDE,A.LA,A.LO,
--(LA - L.LATITUDE)*(LA - L.LATITUDE) AS a,
--(LO - L.LONGITUDE)*(LO - L.LONGITUDE) AS b
(LA - L.LATITUDE)*(LA - L.LATITUDE) + (LO - L.LONGITUDE)*(LO - L.LONGITUDE) AS c
FROM LOCATION_TBL AS L
LEFT OUTER JOIN A
ON L.PF_CODE = A.PF_CODE
WHERE NOT L.DISTRICT_CODE = '1101'),

C AS(
SELECT B.DISTRICT_CODE AS CODE,
D.DISTRICT_NAME AS NAME,
B.LATITUDE AS LAT,
B.LONGITUDE AS LON
FROM B
JOIN DISTRICT AS D
ON B.DISTRICT_CODE = D.DISTRICT_CODE	
ORDER BY c DESC,B.DISTRICT_CODE ASC)

SELECT *
FROM C;


--表示する地区コードに'1101'は含めないこと。
--a² ＝ b² + c²