Hologres这样子的行转列的数据 我一条id为445的过来 但是其余的字段 不想变成空？

你可以使用COALESCE函数来处理这个问题。COALESCE函数会返回第一个非空值，如果所有值都为空，则返回NULL。这样，当某个字段没有对应的值时，它不会变成空。

假设你的表名为t1，字段名为id和name，你可以这样修改你的查询：

SELECT 
    COALESCE(STRING_AGG(distinct case when t3.id = 413 then t2.name end), '') AS name_413,
    COALESCE(STRING_AGG(distinct case when t3.id = 418 then t2.name end), '') AS name_418,
    COALESCE(STRING_AGG(distinct case when t3.id = 421 then t2.name end), '') AS name_421,
    COALESCE(STRING_AGG(distinct case when t3.id = 423 then t2.name end), '') AS name_423,
    COALESCE(STRING_AGG(distinct case when t3.id = 425 then t2.name end), '') AS name_425,
    COALESCE(STRING_AGG(distinct case when t3.id = 428 then t2.name end), '') AS name_428,
    COALESCE(STRING_AGG(distinct case when t3.id = 438 then t2.name end), '') AS name_438,
    COALESCE(STRING_AGG(distinct case when t3.id = 440 then t2.name end), '') AS name_440,
    COALESCE(STRING_AGG(distinct case when t3.id = 443 then t2.name end), '') AS name_443,
    COALESCE(STRING_AGG(distinct case when t3.id = 445 then t2.name end), '') AS name_445
FROM t1 t2
JOIN t3 ON t2.id = t3.id
GROUP BY t2.id

这样，当某个字段没有对应的值时，它将返回一个空字符串，而不是NULL。

你可以使用COALESCE函数来处理这个问题。COALESCE函数会返回第一个非空值，如果所有值都为空，则返回NULL。这样，当某个字段没有对应的值时，它不会变成空。

假设你的表名为t1，字段名为id和name，你可以使用以下查询：

SELECT 
    COALESCE(STRING_AGG(distinct case when t3.id = 413 then t2.name end), '') AS name1,
    COALESCE(STRING_AGG(distinct case when t3.id = 418 then t2.name end), '') AS name2,
    COALESCE(STRING_AGG(distinct case when t3.id = 421 then t2.name end), '') AS name3,
    COALESCE(STRING_AGG(distinct case when t3.id = 423 then t2.name end), '') AS name4,
    COALESCE(STRING_AGG(distinct case when t3.id = 425 then t2.name end), '') AS name5,
    COALESCE(STRING_AGG(distinct case when t3.id = 428 then t2.name end), '') AS name6,
    COALESCE(STRING_AGG(distinct case when t3.id = 438 then t2.name end), '') AS name7,
    COALESCE(STRING_AGG(distinct case when t3.id = 440 then t2.name end), '') AS name8,
    COALESCE(STRING_AGG(distinct case when t3.id = 443 then t2.name end), '') AS name9,
    COALESCE(STRING_AGG(distinct case when t3.id = 445 then t2.name end), '') AS name10
FROM 
    t1 t2
JOIN 
    t3 ON t2.id = t3.id
WHERE 
    t3.id = 445;

这个查询会根据id字段的值将name字段的值聚合到不同的列中。如果某个id没有对应的name值，那么对应的列将为空字符串。