SELECT 
 l.DISTRICT_CODE as CODE
 ,DISTRICT_NAME as NAME
 ,LATITUDE as LAT
 ,LONGITUDE as LON
--  ,pow((select LATITUDE FROM LOCATION_TBL where DISTRICT_CODE = '1101') - LATITUDE,2) + (pow((select LONGITUDE FROM LOCATION_TBL where DISTRICT_CODE = '1101') - LONGITUDE,2)) as a
--  ,(select LATITUDE FROM LOCATION_TBL where DISTRICT_CODE = '1101') - LATITUDE as b
FROM LOCATION_TBL l
 inner join DISTRICT d on d.DISTRICT_CODE = l.DISTRICT_CODE
ORDER BY 
  pow((select LATITUDE FROM LOCATION_TBL where DISTRICT_CODE = '1101') - LATITUDE,2) + (pow((select LONGITUDE FROM LOCATION_TBL where DISTRICT_CODE = '1101') - LONGITUDE,2)) desc
 ,CODE asc;