SQL学习备忘
时间:2022-03-13 23:41
1.按照拼音首字母的正序或倒序排序
1 SELECT 2 CREATOR_REALNAME 3 FROM 4 tableName 5 ORDER BY NLSSORT(CREATOR_REALNAME, ‘NLS_SORT = SCHINESE_PINYIN_M‘) desc拼音排序
参考:
时间:2022-03-13 23:41
1.按照拼音首字母的正序或倒序排序
1 SELECT 2 CREATOR_REALNAME 3 FROM 4 tableName 5 ORDER BY NLSSORT(CREATOR_REALNAME, ‘NLS_SORT = SCHINESE_PINYIN_M‘) desc拼音排序
参考: