SELECT
  A.DISTRICT_CODE AS CODE
 ,B.DISTRICT_NAME AS NAME
 ,A.LATITUDE AS LAT
 ,A.LONGITUDE AS LON
FROM LOCATION_TBL A
INNER JOIN DISTRICT B ON (A.DISTRICT_CODE = B.DISTRICT_CODE)
WHERE A.DISTRICT_CODE != '1101'
ORDER BY
(
   SQRT(ABS((SELECT LATITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101') - A.LATITUDE) * ABS((SELECT LATITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101') - A.LATITUDE) + ABS((SELECT LONGITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101') - A.LONGITUDE) * ABS((SELECT LONGITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE = '1101') - A.LONGITUDE))
 ) DESC,
 A.DISTRICT_CODE ASC