with tmp as(
select 
    DISTRICT_CODE as CODE,
    (select c.DISTRICT_NAME
       from DISTRICT c
      where c.DISTRICT_CODE = a.DISTRICT_CODE) as NAME,
    LATITUDE as LAT,
    LONGITUDE as LON,
(select (a.LATITUDE-b.LATITUDE)
       *(a.LATITUDE-b.LATITUDE)
       +(a.LONGITUDE-a.LONGITUDE)
       *(a.LONGITUDE-a.LONGITUDE)
   from LOCATION_TBL b
  where DISTRICT_CODE = '1101') as distance
  from LOCATION_TBL a
 where DISTRICT_CODE != '1101')
select CODE,NAME,LAT,LON
from tmp
order by distance desc, NAME