select account_number, organization_name, known_as
  from (select account_number,
               organization_name,
               nvl(hop.known_as, hp.known_as) known_as,
               row_number() over(partition by account_number order by hop.creation_date desc) account_fl
          from hz_cust_accounts hca
          left join hz_organization_profiles hop
            on hca.party_id = hop.party_id
          left join hz_parties hp
            on hca.party_id = hp.party_id)
 where account_fl = 1
客户别名 编码 名称 

、使用拼音排序 
　　select * from t order by nlssort(field,'NLS_SORT=SCHINESE_PINYIN_M'); 
2、使用笔画排序 
　　select * from t order by nlssort(field,'NLS_SORT=SCHINESE_STROKE_M'); 
3、使用偏旁部首排序 
　　select * from t order by nlssort(field,'NLS_SORT=SCHINESE_RADICAL_M');