blocks|key|1442194|text|是的，这是可能的，只要数据类型是兼容的。如果不是，则使用CONVERT()或CAST()|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1442195|SELECT+firstname+%2B+'+'+%2B+lastname+AS+name+FROM+customers|code-block|syntax|javascript|1442196|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Yes it's possible, as long as the datatypes are compatible. If they aren't, use a CONVERT() or CAST()

<pre><code>SELECT firstname + ' ' + lastname AS name FROM customers
</code></pre>

blocks|key|3508951|text|是的，您可以非常容易地组合列，例如连接字符数据：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3508952|select+col1+%7C+col+2+as+bothcols+from+tbl+...|code-block|syntax|javascript|3508953|或者添加(例如)数字数据：|3508954|select+col1+%2B+col2+as+bothcols+from+tbl+...|3508955|在这两种情况下，最终都会得到一个包含组合数据的列bothcols。如果列不兼容，则可能必须强制使用数据类型。|offset|length|style|CODE|3508956|entityMap^0|0|0|0|0|O|8|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@$M|X|N|Y|O|P]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

Yes, you can combine columns easily enough such as concatenating character data:

<pre><code>select col1 | col 2 as bothcols from tbl ...
</code></pre>

or adding (for example) numeric data:

<pre><code>select col1 + col2 as bothcols from tbl ...
</code></pre>

In both those cases, you end up with a single column <code>bothcols</code>, which contains the combined data. You may have to coerce the data type if the columns are not compatible.

blocks|key|1442253|text|是,|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1442254|SELECT+CONCAT(field1,+field2)+AS+WHOLENAME+FROM+TABLE
WHERE+...|code-block|syntax|javascript|1442255|将产生如下的数据集：|1442256|WHOLENAME
field1field2|1442257|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Yes,

<pre><code>SELECT CONCAT(field1, field2) AS WHOLENAME FROM TABLE
WHERE ...
</code></pre>

will result in data set like:

<pre><code>WHOLENAME
field1field2
</code></pre>

blocks|key|5108704|text|是的，就像你做的那样：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5108705|select+something+%2B+somethingElse+as+onlyOneColumn+from+someTable|code-block|syntax|javascript|5108706|如果你查询了数据库，你就会得到正确的答案。|5108707|发生的事情是，你请求一个表达式。一个非常简单的表达式只是一个列名，一个更复杂的表达式可以包含公式等等。|5108708|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Yes, just like you did:

<pre><code>select something + somethingElse as onlyOneColumn from someTable
</code></pre>

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.

blocks|key|5108725|text|您的语法应该有效，也许可以在列之间添加一个空格，如下所示|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5108726|SELECT+something+%2B+'+'+%2B+somethingElse+as+onlyOneColumn+FROM+someTable|offset|length|style|CODE|5108727|entityMap^0|0|0|1Y|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Your syntax should work, maybe add a space between the colums like

<code>SELECT something + ' ' + somethingElse as onlyOneColumn FROM someTable</code>

blocks|key|3509048|text|%2B操作符应该可以很好地完成这项工作。但是请记住，如果其中一列为null或没有任何值，它将为您提供NULL结果。取而代之的是，将%2B与函数COALESCE结合使用，您就可以完成设置。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3509049|下面是一个示例：|3509050|SELECT+COALESCE(column1,'')+%2B+COALESCE(column2,'')+FROM+table1.+|code-block|syntax|javascript|3509051|对于本例，如果column1为NULL，则将显示column2的结果，而不是简单的NULL。|3509052|希望这能有所帮助！|3509053|entityMap^0|0|1|1C|4|1R|1|1V|8|0|0|0|7|7|F|4|O|7|15|4|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|11|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|12|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|13|8|@$9|14|A|15|B|C]|$9|16|A|17|B|C]|$9|18|A|19|B|C]|$9|1A|A|1B|B|C]]|D|@]|E|$]]|$1|O|3|P|5|6|7|1C|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]]|R|$]]

The <code>+</code> operator should do the trick just fine. Keep something in mind though, if one of the columns is null or does not have any value, it will give you a <code>NULL</code> result. Instead, combine <code>+</code> with the function <code>COALESCE</code> and you'll be set. 

Here is an example: 

<pre><code>SELECT COALESCE(column1,'') + COALESCE(column2,'') FROM table1. 
</code></pre>

For this example, if <code>column1</code> is <code>NULL</code>, then the results of <code>column2</code> will show up, instead of a simple <code>NULL</code>. 

Hope this helps!

blocks|key|2074313|text|(SELECT+column1+as+column+FROM+table+)
UNION+
(SELECT+column2+as+column+FROM+table+)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2074314|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>(SELECT column1 as column FROM table )
UNION 
(SELECT column2 as column FROM table )
</code></pre>

blocks|key|1442424|text|如果其中一列是我经历过的数字，则oracle会将'%2B‘视为sum运算符，而不是串联。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1442425|例如：|1442426|select+(id+%2B+name)+as+one+from+table+1;+(id+is+numeric)+|code-block|syntax|javascript|1442427|抛出无效的数字异常|1442428|在这种情况下，您可以%7C%7C运算符，这是连接。|1442429|select+(id+%7C%7C+name)+as+one+from+table+1;|1442430|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|V|8|@]|9|@]|A|$G|H]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

if one of the column is number i have experienced the oracle will think '+' as sum operator instead concatenation. 

eg:

<pre><code>select (id + name) as one from table 1; (id is numeric) 
</code></pre>

throws invalid number exception

in such case you can || operator which is concatenation.

<pre><code>select (id || name) as one from table 1;
</code></pre>

blocks|key|3509104|text|其他答案对我都不起作用，但这个答案起作用了：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3509105|SELECT+CONCAT(Cust_First,+'+',+Cust_Last)+AS+CustName+FROM+customer|code-block|syntax|javascript|3509106|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

None of the other answers worked for me but this did:

<pre><code>SELECT CONCAT(Cust_First, ' ', Cust_Last) AS CustName FROM customer
</code></pre>

blocks|key|1442475|text|我希望这个答案能有所帮助：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1442476|SELECT+(CAST(id+AS+NVARCHAR)%2B','%2Bname)+AS+COMBINED_COLUMN+FROM+TABLENAME;|code-block|syntax|javascript|1442477|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I hope this answer helps:

<pre><code>SELECT (CAST(id AS NVARCHAR)+','+name) AS COMBINED_COLUMN FROM TABLENAME;
</code></pre>

blocks|key|2071713|text|select+column1+%7C%7C+'+'+%7C%7C+column2+as+whole_name+FROM+tablename;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2071714|这里，%7C%7C是用于将它们连接到单个列的concat运算符，而%7C%7C内部的('')用于两列之间的空格。|unstyled|offset|length|style|CODE|2071715|entityMap^0|0|3|2|T|2|Z|2|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@$G|O|H|P|I|J]|$G|Q|H|R|I|J]|$G|S|H|T|I|J]]|9|@]|A|$]]|$1|K|3|-4|5|F|7|U|8|@]|9|@]|A|$]]]|L|$]]

<pre><code>select column1 || ' ' || column2 as whole_name FROM tablename;
</code></pre>

Here <code>||</code> is the concat operator used for concatenating them to single column and (<code>''</code>) inside <code>||</code> used for space between two columns.

blocks|key|3509166|text|SELECT+firstname+%7C%7C+'+'+%7C%7C+lastname+FROM+users;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3509167|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre class="lang-sql prettyprint-override"><code>SELECT firstname || ' ' || lastname FROM users;
</code></pre>

blocks|key|1442577|text|为了完成@Pete卡特的回答，我将在UNION上添加一个"ALL“(如果您需要保留重复的条目)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1442578|(从表中选择column1作为列)|1442579|联合所有|1442580|(从表中选择column2作为列)|1442581|+DROP+TABLE+IF+EXISTS+#9
++++CREATE+TABLE+#9+
(
++++USER1+int
++++,USER2+int
)
INSERT+INTO+#9
+VALUES(1,+2),+(1,+3),+(1,+4),+(2,+3)
+------------------------------------------------
(SELECT+USER1+AS+'column'+from+#9)
+UNION+ALL
+(SELECT+USER2+AS+'column'+from+#9)|code-block|syntax|javascript|1442582|然后返回：Result|offset|length|1442583|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/MyWQ7.png^0|0|0|0|0|0|5|6|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|12|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|13|8|@]|9|@$O|14|P|15|1|16]]|A|$]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

To complete the answer of @Pete Carter, I would add an &quot;ALL&quot; on the UNION (if you need to keep the duplicate entries).
(SELECT column1 as column FROM table )
UNION ALL
(SELECT column2 as column FROM table )
<pre><code> DROP TABLE IF EXISTS #9
 CREATE TABLE #9 
(
 USER1 int
 ,USER2 int
)
INSERT INTO #9
 VALUES(1, 2), (1, 3), (1, 4), (2, 3)
 ------------------------------------------------
(SELECT USER1 AS 'column' from #9)
 UNION ALL
 (SELECT USER2 AS 'column' from #9)
</code></pre>
Would then return : <a href="https://i.stack.imgur.com/MyWQ7.png" rel="nofollow noreferrer">Result</a>

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

Example: 

<code>select something + somethingElse as onlyOneColumn from someTable</code>

Select 2 columns in one and combine them

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

是否可以在一列中选择两列并将其组合？示例：select something + somethingElse as onlyOneColumn from someTable

问在一列中选择两列并将其合并
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在一列中选择两列并将其合并EN