select
   sum(case when substring(Tilno from 1 for 1) = '1' then  cast(COALESCE(amnt,0) as numeric(13))
           else 0                                                                             
   end) "1번계",
   sum(case when substring(Tilno from 1 for 1) = '2' then  cast(COALESCE(amnt,0) as numeric(13))
           else 0                                                                             
   end) "2번계",
   sum(case when substring(Tilno from 1 for 1) = '1' then 0
            when substring(Tilno from 1 for 1) = '2' then 0
            else cast(COALESCE(amnt,0) as numeric(13))
   end) "기타계",
   cast(sum(COALESCE(amnt,0)) as numeric(13)) "총  계"
from tr110t
이리 하니 되는군요...  저것이 문법에 맞는줄 모르지만 테스트하니 잘 맞는군요...