Difference between revisions of "Concatenate Columns"
From SQLZOO
| 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:scott</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. | ||
Revision as of 12:55, 12 July 2012
You can put two or more strings together using the concatenate operator.
schema:scott
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.
DROP TABLE bbc;
CREATE TABLE bbc (name VARCHAR(10), region VARCHAR(10)); INSERT INTO bbc VALUES ('Poland', 'Europe'); INSERT INTO bbc VALUES ('Japan', 'Asia');
SELECT region & name FROM bbc
SELECT region + name FROM bbc
SELECT CONCAT(region, name) FROM bbc
SELECT region || name FROM bbc
Concatenate Columns
