array_agg(expression)
把表达式变成一个数组 一般配合 array_to_string() 函数使用
string_agg(expression, delimiter)
直接把一个表达式变成字符串
以某个字段group by分组,查询多个字段 (存在某些字段有重复项)取其中一个,或者合并返回
示例:
SELECT
"identity",
"name",
gender,
card_type,
( ARRAY_AGG ( birthday ORDER BY verify_time DESC ) ) [ 1 ] AS birthday,--取其中一个
( ARRAY_AGG ( address ORDER BY verify_time DESC ) ) [ 1 ] AS address,--取其中一个
string_agg (DISTINCT(T .address), ',') AS address2 -- 逗号分隔,罗列数据
"count" ( 1 )
FROM
biz_v11_record
GROUP BY
"identity",
"name",
gender,
card_type