Sql: how to concatenate columns in a select statement?

Example:

Copy Code
SELECT first_name || ' ' || last_name AS full_name FROM employees;

In SQL, you can concatenate columns to form a single combined column in the output.

Solution:

Copy Code
SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM employees;