Difference between revisions of "Concatenate Columns"
From SQLZOO
| (5 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
You can put two or more strings together using the concatenate operator. | You can put two or more strings together using the concatenate operator. | ||
<div class='ht'> | <div class='ht'> | ||
| − | < | + | <div class=params>schema:gisq</div> |
<div> | <div> | ||
You can put two or more strings together using the concatenate operator. | You can put two or more strings together using the concatenate operator. | ||
| Line 7: | Line 7: | ||
between the main vendors. | between the main vendors. | ||
</div> | </div> | ||
| − | <source lang=sql class='tidy'> | + | <source lang=sql class='tidy'></source> |
| − | + | <source lang=sql class='setup'></source> | |
| − | + | ||
| − | </source> | + | |
<source lang='sql' class='def e-access'>SELECT region & name | <source lang='sql' class='def e-access'>SELECT region & name | ||
FROM bbc</source> | FROM bbc</source> | ||
Latest revision as of 13:01, 12 July 2012
You can put two or more strings together using the concatenate operator.
schema:gisq
You can put two or more strings together using the concatenate operator. The SQL standard says you should use || but there are many differences between the main vendors.
SELECT region & name FROM bbc
SELECT region + name FROM bbc
SELECT CONCAT(region, name) FROM bbc
SELECT region || name FROM bbc
Concatenate Columns
