ORACLE汉字排序 取分组最大时间记要 ebs客户别名 编码 名称

ORACLE汉字排序 取分组最大时间记录 ebs客户别名 编码 名称

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');