SQL
Galaxy●K
coder!
展开
-
PostgreSql的聚合函数string_agg和自定义聚合函数group_concat
1.使用自定义聚合函数 group_concat SELECT * FROM ( SELECT "FFID",CAST ("BRDNO" AS INTEGER),"count" (*) AS "NUM", array_to_string(group_concat("PRSTA"), ',') AS "PRSTA" FROM "metaHe原创 2018-11-07 11:32:26 · 8078 阅读 · 2 评论 -
Oracle,MySql和PostGreSql对中文字段按拼音排序
1.oracle SELECT * FROM TABLE ORDER BY NLSSORT(chineseColumnName,'NLS_SORT = SCHINESE_PINYIN_M'); 2.mysql --字符编码是utf8_general_ci SELECT * FROM TABLE ORDER BY CONVERT(chineseColumnName USING gbk) COLL...原创 2019-02-20 10:00:32 · 858 阅读 · 0 评论