在一列中选择2列并将其合并 [英] Select 2 columns in one and combine them

问题描述

是否可以在一列中选择2列并将其合并?

Is it possible to select 2 columns in just one and combine them?

示例:

select something + somethingElse as onlyOneColumn from someTable

推荐答案

是的，就像您所做的一样:

Yes, just like you did:

select something + somethingElse as onlyOneColumn from someTable

如果查询数据库，您将获得正确的答案.

If you queried the database, you would have gotten the right answer.

会发生什么事，您要求一个表达式.一个非常简单的表达式只是一个列名，一个更复杂的表达式中可以包含公式等.

What happens is you ask for an expression. A very simple expression is just a column name, a more complicated expression can have formulas etc in it.

这篇关于在一列中选择2列并将其合并的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！