在下面的请求中:
我得到了以下结果:
如何去除
SELECT
myid,
min(name) AS name,
array_agg(array[zip, city])) AS city
FROM my_table
WHERE name LIKE 'Doe'
GROUP BY myid
LIMIT 10
我得到了以下结果:
+-------+------+-------------------+
| myid | name | city |
+-------+------+-------------------+
| A123 | Doe | {{69,"Groville"}} |
| B456 | Doe | {{NULL,NULL}} |
+-------+------+-------------------+
如何去除
NULL
值并将city
字段替换为空?
min(name)
而是先聚合所有的名字然后再选择一个呢? - user330315