双杠(||)在SQL中是什么意思? [英] What does double bars (||) mean in SQL?
本文介绍了双杠(||)在SQL中是什么意思?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试理解以下查询:
select count(distinct Name || '' || Surname) from PEOPLE;
双杠是什么意思?该查询的作用是什么?
I'm trying to understand the following query:
select count(distinct Name || '' || Surname) from PEOPLE;
What does the double bars mean? What does this query do?
在MySQL中:
select "aaaaa" || '' || "bbbbb";
In MySQL:
select "aaaaa" || '' || "bbbbb";
+--------------------------+
| "aaaaa" || '' || "bbbbb" |
+--------------------------+
| 0 |
+--------------------------+
+--------------------------+
| "aaaaa" || '' || "bbbbb" |
+--------------------------+
| 0 |
+--------------------------+
推荐答案
双杠是隐喻的:
select 'hello' || ' ' || 'world' from dual;
收益
'hello world'
这篇关于双杠(||)在SQL中是什么意思?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文