如何对网站做镜像,销售的网络建设,安全的企业网站开发,极客优选网上商城系统中英文分开排序http://hi.baidu.com/flowerhacker/blog/item/dfb0961e383662154034174f.html我同事问了个问题#xff1a;是将中文和英文分开排序。是先排中文#xff0c;再排英文的#xff0c;都按照拼音abc那样排的#xff1b;字段都是英文打头算作英文#xff0c;中文打…中英文分开排序http://hi.baidu.com/flowerhacker/blog/item/dfb0961e383662154034174f.html我同事问了个问题是将中文和英文分开排序。是先排中文再排英文的都按照拼音abc那样排的字段都是英文打头算作英文中文打头算作中文。如果是先排英文的话可以直接用NLSSORT(排序字段,NLS_SORT SCHINESE_PINYIN_M)进行排序。如果是先中文再英文的话。我用是先区分中英文然后再排序SELECT *FROM (SELECT A.*, ROWNUM RNFROM (SELECT *FROM T_GYSWHERE UPPER(SUBSTR(MC, 1, 1)) NOT IN(A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z)ORDER BY NLSSORT(MC, NLS_SORT SCHINESE_PINYIN_M) ASC) AUNIONSELECT B.*,ROWNUM (SELECT MAX(ROWNUM) RNFROM T_GYSWHERE UPPER(SUBSTR(MC, 1, 1)) NOT IN(A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z)) RNFROM (SELECT *FROM T_GYSWHERE UPPER(SUBSTR(MC, 1, 1)) IN(A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z)ORDER BY NLSSORT(MC, NLS_SORT SCHINESE_PINYIN_M) ASC) B) TORDER BY T.RN ASC;
