SQLite 选择两列作为一列与 Null [英] SQLite selecting two columns as one with Null

问题描述

如果其中一列有 Null，我将如何组合这两列?

How would I combine the two columns if there is a Null in one of them?

SELECT (column1 || " " || column2) AS expr1 FROM your_table;

我希望输出为:

推荐答案

SELECT (COALESCE(column1,'') || " " || COALESCE(column2, '')) AS expr1 FROM your_table;

这篇关于SQLite 选择两列作为一列与 Null的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！