select T.DISTRICT_CODE                                                 as CODE,
       DISTRICT_NAME                                                   as NAME,
       T.LATITUDE                                                        as LAT,
       T.LONGITUDE                                                       as LON
--        sqrt((T.latitude - B.latitude) * (T.latitude - B.latitude) +
--             (T.longitude - B.longitude) * (T.longitude - B.longitude)) as dict
from LOCATION_TBL T
         inner join DISTRICT on T.DISTRICT_CODE = DISTRICT.DISTRICT_CODE,
     (select * from LOCATION_TBL where DISTRICT_CODE = '1101') as B

where T.DISTRICT_CODE <> '1101'
order by ((T.latitude - B.latitude) * (T.latitude - B.latitude) +
               (T.longitude - B.longitude) * (T.longitude - B.longitude)) desc,
         1