Oracle 中文字段进行排序的sql语句
程序员文章站
2023-11-17 11:07:46
1）按笔画排序 select * from table order by nlssort(columnname,'nls_sort=schinese_stroke_m')...
1）按笔画排序
select * from table order by nlssort(columnname,'nls_sort=schinese_stroke_m')
2）按部首排序
select * from table order by nlssort(columnname,'nls_sort=schinese_radical_m')
3）按拼音排序
select * from table order by nlssort(columnname,'nls_sort=schinese_pinyin_m');
select * from table order by nlssort(columnname,'nls_sort=schinese_stroke_m')
2）按部首排序
select * from table order by nlssort(columnname,'nls_sort=schinese_radical_m')
3）按拼音排序
select * from table order by nlssort(columnname,'nls_sort=schinese_pinyin_m');
上一篇： 百度推移动站点打赏功能 内测中
下一篇： 会声会影x10怎么制作淘宝正方形视频?