Concatenate Columns

From SQLZoo
Jump to navigation Jump to search

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
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects