SQL对字符串进行排序
标签：style blog ar color sp on div log bs
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://www.haodehen.cn/did118468
SQL对字符串进行排序
BEGIN
2 DECLARE inString CHAR ( 7 );
3 SET inString = ‘ DCDBAAB ‘ ;
4
5 REPLICATE ( ‘ A ‘ , (DATA_LENGTH(inString) - DATA_LENGTH( REPLACE (inString, ‘ A ‘ , ‘‘ ))))
6 ||
7 REPLICATE ( ‘ B ‘ , (DATA_LENGTH(inString) - DATA_LENGTH( REPLACE (inString, ‘ B ‘ , ‘‘ ))))
8 ||
9 REPLICATE ( ‘ C ‘ , (DATA_LENGTH(inString) - DATA_LENGTH( REPLACE (inString, ‘ C ‘ , ‘‘ ))))
10 ||
11 REPLICATE ( ‘ D ‘ , (DATA_LENGTH(inString) - DATA_LENGTH( REPLACE (inString, ‘ D ‘ , ‘‘ ))))
12
13 END ;
阅读：24次