select 
a.DISTRICT_CODE as CODE
,b.DISTRICT_NAME as NAME
,a.LATITUDE as LAT
,a.LONGITUDE as LON
--,SQRT(POW(LATITUDE-LATITUDE_1101,2)+POW(LONGITUDE-LONGITUDE_1101,2)) as dist
from 
(
    select 
    PF_CODE
    ,DISTRICT_CODE
    ,LATITUDE
    ,LONGITUDE
    ,(select LATITUDE from LOCATION_TBL where DISTRICT_CODE='1101' ) as LATITUDE_1101
    ,(select LONGITUDE from LOCATION_TBL where DISTRICT_CODE='1101' ) as LONGITUDE_1101
    from LOCATION_TBL
    where DISTRICT_CODE!='1101'
)a
INNER JOIN 
DISTRICT b
On
a.DISTRICT_CODE = b.DISTRICT_CODE
order by
SQRT(POW(LATITUDE-LATITUDE_1101,2)+POW(LONGITUDE-LONGITUDE_1101,2)) desc
,a.DISTRICT_CODE