with 
    p_1101 as(
        select
            LATITUDE
            ,LONGITUDE
        from 
            LOCATION_TBL
        where DISTRICT_CODE='1101'
        )
    ,sub as(
        select
            LOCATION_TBL.DISTRICT_CODE as DISTRICT_CODE
            ,LOCATION_TBL.LATITUDE as LATITUDE
            ,LOCATION_TBL.LONGITUDE as LONGITUDE
            ,SQRT(
             (LOCATION_TBL.LATITUDE-p_1101.LATITUDE)*(LOCATION_TBL.LATITUDE-p_1101.LATITUDE)+
             (LOCATION_TBL.LONGITUDE-p_1101.LONGITUDE)*(LOCATION_TBL.LONGITUDE-p_1101.LONGITUDE)
             )as leach
        from LOCATION_TBL
        join p_1101
        )
--select * from sub
    ,sub2 as(
        select
            sub.DISTRICT_CODE as DISTRICT_CODE
            ,sub.LATITUDE as LATITUDE 
            ,sub.LONGITUDE as LONGITUDE
            ,row_number()over(order by leach desc) as row
        from sub
        where DISTRICT_CODE <> '1101'
        )
--select * from sub2

select
    sub2.DISTRICT_CODE as CODE
    ,DISTRICT.DISTRICT_NAME as NAME
    ,sub2.LATITUDE as LAT
    ,sub2.LONGITUDE as LON
from 
    sub2
    inner join DISTRICT
    on sub2.DISTRICT_CODE = DISTRICT.DISTRICT_CODE
order by
    sub2.row desc
    ,CODE asc