如何添加一列全部值为空的列?

如下图,怎么将0 as value,替换为NULL as value。直接写NULL as value不行。

attachments-2021-07-YlhpFXoO60ed5e0170afa.png

请先 登录 后评论

1 个回答

Juntao Wang
t = table(1..10 as id, rand(1..100, 10) as value)
select id, int(NULL) as value from t
请先 登录 后评论