在一列中选择2列并将其合并

在一列中选择2列并将其合并

问题描述:

是否可以在一列中选择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.