query的输出如下所示:
Select hostname,support1,support2 From hostnames where hostname in ('C')
C | NULL | NULL
C | NULL | B
C | A | NULL
C | A | B
如您所见,这里有NULL | B
和A | NULL
。我需要输出为:
C | A | B
(将两行合并为一行)如何操作?谢谢
发布于 2018-06-08 05:48:48
您可以使用聚合:
Select hostname, max(support1) as support1, max(support2) as support2
From hostnames
where hostname in ('C')
group by hostname;
https://stackoverflow.com/questions/50750593
复制相似问题