kingberrill of SQL
6/1/2017 - 9:05 PM

Concatenate (Adding Text Columns Together)

Concatenate (Adding Text Columns Together)

-- Use the concatenation operator ||
-- NOTE: added " " to add spacing between each column value

SELECT  first_name || " " || last_name AS "Name" FROM table_name;


-- add username after review in same column
SELECT review || " - " || username AS "REVIEWS" FROM reviews;