select

lt.DISTRICT_CODE as CODE,
dis.DISTRICT_NAME as NAME,
lt.LATITUDE as LAT,
lt.LONGITUDE as LON

from LOCATION_TBL as lt
join DISTRICT as dis
using(DISTRICT_CODE)

where DISTRICT_CODE != 1101
order by

POWER(LATITUDE- (select (LATITUDE)  from LOCATION_TBL where DISTRICT_CODE = 1101),2) +
POWER(LONGITUDE-(select (LONGITUDE) from LOCATION_TBL where DISTRICT_CODE = 1101),2)
desc,1
;